Mahesh Ishwar wrote:

>Hello,
>Can I have row level & statement level triggers just like that in Oracle?
>

Firebird supports only row level triggers. In other words, for a
statement like

update x set y = y + 1

the condition is evaluated on every row. Some operations require
multiple updates to move the database from one consistent state to
another. Oracle (and others) have statement level triggers that are
evaluated when the statement completes, not when each row is changed.
They're useful. We never implemented them because we didn't keep a list
of the rows affected by a statement so they could be examined at the end
of the statement. Firebird now keeps that information, so implementing
statement level triggers would be (reasonably) easy.

Regards,


Ann