Quick reference - Oracle DML and DDL statements

Just a quick reference of DML and DDL Oracle Statements and some links to visit.

DML Statements

Insert

INSERT INTO table_name (list_of_columns)
VALUES (list_of_values);

Update

UPDATE table_name
SET column_name = value [, column_name = value]…
[ WHERE condition ];

Delete

DELETE FROM table_name
[ WHERE condition ];

Create

CREATE TABLE table_name
(
column1 datatype [ NULL | NOT NULL ],
column2 datatype [ NULL | NOT NULL ],
…
column_n datatype [ NULL | NOT NULL ] );

Alter

ALTER TABLE table_name
ADD column_name column-definition;

Drop

DROP [schema_name].TABLE table_name
[ CASCADE CONSTRAINTS ] [ PURGE ];

Some sites which contains interesting information about the last topics: