Thursday, August 23, 2012

SQL Command Types


Data Definition Language (DDL) .


 The query and manipulate data in existing schema objects. These commands do not implicitly commit the current transaction.  

LIKE
ALTER SEQUENCE       DROP INDEX 
ALTER TABLE            DROP PROCEDURE 
ALTER TRIGGER       CREATE SEQUENCE      
ALTER USER             DROP SEQUENCE 
ALTER VIEW               CREATE TABLE      

Data Manipulation Language (DML).

LIKE
DELETE            
INSERT            
UPDATE  

Transaction Control Commands.

LIKE
COMMIT            
ROLLBACK            
SAVEPOINT            
SET TRANSACTION

Pseudocolumns.

LIKE  
CURRVAL
NEXTVAL   
LEVEL      
ROWID
ROWNUM

No comments:

Post a Comment