SQL Statements

SQL Statements

Oracle SQL complies with industry-accepted standards. Oracle Corporation ensures future
compliance with evolving standards by actively involving key personnel in SQL standards
committees. Industry-accepted committees are the American National Standards Institute (ANSI)and the International Standards Organization (ISO). Both ANSI and ISO have accepted SQL as the standard language for relational databases.

Statement Description

• SELECT Retrieves data from the database
  
• INSERT,UPDATE,DELETE,MERGE

Enters new rows, changes existing rows, and removes unwanted rows

from tables in the database, respectively. Collectively known as data

manipulation language (DML).

• CREATE,ALTER,DROP,RENAME,TRUNCATE

Sets up, changes, and removes data structures from tables. Collectively

known as data definition language (DDL).

• COMMIT,ROLLBACK,SAVEPOINT

Manages the changes made by DML statements. Changes to the data can

be grouped together into logical transactions.

• GRANT,REVOKE

Gives or removes access rights to both the Oracle database and the

structures within it. Collectively known as data control language

(DCL).