December 2015

When should we use Row level DML triggers

By | 2017-07-21T21:43:24+00:00 December 18th, 2015|Oracle|

A trigger is like a stored procedure that Oracle Database invokes automatically whenever a specified event occurs. Row level DML triggers are invoked for every row the specified DML statement touches (insert/update/delete). Since the database has to execute the trigger’s execution block in addition to the DML that invoked the trigger, by creating a trigger we [...]

July 2013

Oracle Alter Table

By | 2017-07-21T21:43:34+00:00 July 29th, 2013|Oracle|

What is Alter Statement: Alter statement is the part of DDL (Data Definition Language). Which is used to change (Alter) the definition of a table. […]

October 2012

September 2012

July 2012

June 2012