Oracle Base Statement

SQL statement Classification

Select query statement??

DML statement (Data manipulation language) Insert, Update, Delete, Merge??

DDL statements (data definition language) Create, Alter, Drop, Truncate??

DCL Statement (Data Control Language) Grant, Revoke?? Transaction control Statements Commit, Rollback, savepoint

Basic SELECT statement

SELECT *| {[DISTINCT] column|expression [alias],...}

from table;

Select identifies which columns are selected.

from which table the from identity is selected

SQL language Features

SQL language is not case sensitive.

SQL can be written in one line or multiple lines

Keywords cannot be abbreviated or branch

The clauses are usually written in branches.

Use indentation to improve the readability of the statement.

Tips

Delete duplicate rows using the keyword ' DISTINCT ' in the SELECT clause.

Use the DESCRIBE command to represent the table structure

Oracle Base Statement