Wednesday, October 1, 2008

Types of SQL Statement - oracle

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.


No comments:

Post a Comment

Thanks to given comments.......

My Blog List