SQL Commands

• SQL Commands
  
  • DDL(Data Definition Language)
    
    • create
      
    • drop
      
    • alter
      
    • tgruncate
      
    • rename
      
  • DML(Data Manipulation Language)
    
    • insert
      
    • update
      
    • delete
      
    • call
      
      • Call a PL/SQL or JAVA subprogram
        
    • explain call
      
    • lock
      
  • DQL(Data Query Language)
    
    • select
      
  • TCL(Transaction Control Language)
    
    • commit
      
    • savepoint
      
    • rollback
      
    • set transaction
      
    • set constraint
      
  • DCL(Data Control Language)
    
    • grant
      
    • revoke
      
  • CCL(Cursor Control Language)
    
    • DECLARE CURSOR, FETCH INTO, and UPDATE WHERE CURRENT are used to perform single line operations on one or more forms