DML Statements

The BNF notations for DML statements follow:

INSERT INTO <table_or_view_name> [(<column_name>,...)] {{VALUES (<literal> |             <expression> |            NULL |            DEFAULT,...)} |    {<select_statement>} } 

UPDATE <table_or_view_name> SET {<column_name> = <literal> |                       <expression> |                       <single_row_select_statement> |                      NULL |                       DEFAULT,...} [WHERE <predicate>] 

DELETE FROM <table_or_view_name> WHERE <predicate>