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

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!

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;

SQL> @ C:\oracle8\PLSQL\dept_tr Hello Dima: Thanks for your input. But after I added the colon in front of NEW, then another ERROR was coming up? SQL> CREATE OR REPLACE TRIGGER DEPT_TR 2 AFTER INSERT OR UPDATE 3 ON DEPT 4 BEGIN 5 If :new.loc = 'Houston' Then 6...