--Developing Oracle Applications with Developer/2000
--@\DEV2000\SQL\UPDATE.SQL

--spool \DEV2000\SQL\UPDATE.TXT

Prompt Developing Oracle Applications with Developer/2000
Prompt Updating Dept Table for...

select substr (user,1,20) User_Id,
sysdate Sys_Date,
substr (to_char(sysdate, 'HH:MIAM'),1,10) Sys_Time from dual;

Prompt Updating Increase_Pct Column in Table Dept...

UPDATE DEPT
SET Increase_Pct = 100;

Prompt Done Updating Increase_Pct Column in Table Dept.

Prompt Updating Increase_Pct Column in Table Emp...

UPDATE EMP
SET Increase_Pct = 100;

Prompt Done Updating Increase_Pct Column in Table Emp.

--spool off;
