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