Search results for query: *

I have some data in my table declared in varchar 2000 200 20 2 Is any way I can write a SQL to output those data as 2000 0200 0020 0002 Many Thanks

By the way, Thanks for BOTH input!!! Best Regards Owen

Thanks Alan ..... I will try the first Query.

There is the table: ColA ColB ColC ColD 0001 00011574 111500 Purchases Cost Pool 0001 00010001 280001 Home Office 0002 09910001 280001 Home Office 0001 00010002 280002 Short North 0001 00010003 280003 Affinity Deposits Is any way I can write a SQL query to...

Sorry Alex: I am very new in Oracle. Don't know anyone can give me more details for step by step? Thanks

How to move the logfile members from $ORACLE_BASE/oradata/ to $ORACLE_BASE/oradata/test? Thanks

How to change the password of the system user using alter user command?

Do you know the name of the admin scripts which is stored in the %ORACLE_HOME\rdbms\admin directory? I am new for Oracles, it does have lot of scripts inside this folder. Thanks

Thanks All: Best Regards Owen

Hi all: How can I identify the instance name? Also, is anyway I can find out the version of the database?

Salesman# -> Commission% Commission is depend on the Saleman# Example: Tom will have fixed 7% commission for selling any type of cars. Date_sold -> Discount_amt Example: Dec 25 2002 will have $300 discount for any car. Dec 10 2002 will have $100 discount for any car.

Any comment for my Normal form concept is right .... CAR_SALE TABLE (Car #, Date_sold, Salesman#, Commission%, Discount_amt) Assume that a car may be sold by multiple salesman and hence {Car #, Salesman#} is the primary key. Additional dependencies are: Date_sold -> Discount_amt, and...

...emp.sal, dept.dname FROM emp , dept WHERE emp.sal IS NOT NULL and emp.deptno = dept.deptno ORDER BY emp.sal DESC; BEGIN Select count(*) into v_count from EMP; If (v_num <= 0) or (v_count < v_num) Then RAISE Wrong_Input; End if; OPEN emp_cursor; FETCH emp_cursor INTO...

Thanks for your inputs.

Sorry, it is NT!

Hello all: Is any command that I can identify the instance name, database vesion, database name and the its block size?

Hello Robbie: I type in SYS/change_on_install. But can't start the SQLPLUS. No matter what, I am going to format my PC(too much Garbages) & reload all softwares which also including of a fresh copy of Oracle 9i. And see does it work. By the way, thanks for your input!!!

Hi: I am newbie for Oracle. I do have Oracle 9i database Personal ver install in my PC. Question: I open the SQLPLUS, Pop up Diolag Box ask for User & Password. Since I want be in DBA role to create database, tablespace, new user & grant this new user as DBA priviledges. So inside the...

Thanks Dima: NOW IS WORKING FINE NOW & REALLY THANKS FOR YOUR INPUT!!! CREATE OR REPLACE TRIGGER DEPT BEFORE INSERT OR UPDATE ON DEPT FOR EACH ROW BEGIN IF :NEW.LOC = 'Houston' THEN :NEW.LOC := 'Chicago'; END IF; END;

...UPDATE 3 ON DEPT 4 BEGIN 5 If :new.loc = 'Houston' Then 6 :new.loc := 'Chicago'; 7 End If; 8 END; 9 / CREATE OR REPLACE TRIGGER DEPT_TR * ERROR at line 1: ORA-04082: NEW or OLD references not allowed in table level...