Recent content by owenyuen

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...

SET SERVEROUTPUT ON SET VERIFY OFF SET ECHO OFF ACCEPT p_num PROMPT 'Please enter the number of top money makers: ' DECLARE Wrong_Input EXCEPTION; v_num NUMBER(2) := &p_num; v_ename emp.ename%TYPE; v_sal emp.sal%TYPE; v_dept dept.dname%TYPE; tmp_sal emp.sal%TYPE; v_count Number...

Thanks for your inputs.

Sorry, it is NT!