Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

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;