SQL Sub Languages

DATA DEFINITION LANGUAGE (DDL)

  • CREATE
  • ALTER
  • DROP
  • TRUNCATE
  • RENAME (oracle 9i)

DATA MANIPULATION LANGUAGE (DML)

  • INSERT
  • UPDATE
  • DELETE
  • MERGE (oracle 9i onwards)

DATA QUERY LANGUAGE (OR) DATA RETRIVAL LANGUAGE

  • SELECT

TRANSACTION CONTROL LANGUAGE (TCL)

  • COMMIT
  • ROLLBACK
  • SAVEPOINT

DATA CONTROL LANGUAGE (DCL)

  • GRANT
  • REVOKE

User/Password

  • Scott /Tiger are Only Available in Enterprise Editions
  • System / manager are the Common for all the Oracle Editions