Types of SQL Statement
What are the types of SQL Statement ?
Data Definition Language :
CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.
Data Manipulation Language:
INSERT,UPDATE,DELETE,LOCK
TABLE,EXPLAIN PLAN & SELECT.Transactional Control:
COMMIT & ROLLBACKSession Control: ALTERSESSION & SET
ROLESystem Control :
ALTER SYSTEM.
Related posts:
- Concurrency What is concurrency? Cuncurrency is allowing simultaneous access...
- After commit statement What will happen after commit statement ? Cursor...
- Types of database triggers How many types of database triggers can be specified...
- Generating an EXPLAIN plan How would you go about generating an EXPLAIN plan?...
- Usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE...
Related posts brought to you by Yet Another Related Posts Plugin.