SYNTAx:CREATE TABLE STAFF-TEMPMST AS SELECT * FROM STAFF-MASTER
-- Adding records from another table
SYNTAx: INSERT 1*+ APPEND *1 INTO STAFF-MASTER ( NAME, DATE-OF-BIRTH, PAY ) SELECT NAME, DATE-OF-BIRTH, PAY FROM STAFF-TEMPMST WHERE NAME NOT IN (SELECT NAME FROM STAFF-MASTER )
How to update records I rows into a table
-- updating one column on condition.
SYNTAx : UPDATE STAFF-MASTER SET PAY= 50000 WHERE PAY
> 50000
-- updating column for all rows
SYNTAx UPDATE STAFF-MASTER SET PAY = PAY + 5000
How to delete records I rows in a table
-- deleting few rows on meeting condition
SYNTAx : DELETE STAFF-MASTER WHERE DATE-OF-BIRTH IS NULL
-- deleting all rows
SYNTAx TRUNCATE TABLE STAFF-MASTER;