DML Statements

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>