On Fri, 28 Feb 2003, Susan Hoddinott wrote:
> Having scoured the relevant documentation I cannot find anything which
> indicates how I simply create a database trigger to insert into a
> second table after insert on a first table, without the use of a
> procedure. As I do not want return values etc. this seems like
> overkill. Is it possible to create a trigger which executes SQL
> directly without the need to create a procedure? If so, what is the
> syntax?
Not really... You'll need to wrap it in a simple function.