Learn General Oracle/SQL Query Writing :
Quick Reference Oracle SQL Query writing. Go through this post and learn Oracle SQL writing within couple of hours. Quick reference Oracle DML,DDL,DCL Operations.
SELECT Retrieves data from the database.
INSERT ,UPDATE,DELETE,MERGE
Enters new rows, changes existing rows, and removes unwanted rows from tables in the database, respectively. Collectively known as data manipulation language (DML).
CREATE, ALTER ,DROP
RENAME
TRUNCATE
Sets up, changes, and removes data structures from tables. Collectively known as data
Definition language (DDL).
COMMIT
ROLLBACK
SAVEPOINT
Manages the changes made by DML statements. Changes to the data can be grouped together into logical transactions.
GRANT
REVOKE
