PL/SQL Reference

 

 

27-Feb-13

Trigger syntax

create [or replace] trigger [schema .] trigger_identifier
{ before | after | instead of }
{ dml_event_clause
| { ddl_event [or ddl_event]...
　　| database_event [or database_event]...
　　}
　　on { [schema .] schema | database }
}
[when ( condition ) ]

{ pl/sql_block | call_procedure_statement }

 

Update syntax

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value