|
<<Previous
Next>>
Oracle - Advantage of a stored procedure over a database
trigger - Feb 18, 2010 at 11:00 PM by Rajmeet Ghai
Advantage of a stored procedure over a database trigger.
Stored procedures can accept parameters and can return values. Triggers can
neither accept parameters nor return values. A Trigger is dependent on a table
and the application has no control to not fire a trigger when not needed. On
the other hand, a stored procedure can be called as needed.
Oracle - Advantage of a stored procedure over a database
trigger - Feb 07, 2010 at 14:20 PM by Shuchi Gauri
Advantage of a stored procedure over a database
trigger.
Firing of a stored procedure can be controlled whereas on the other hand trigger
will get fired whenever any modification takes place on the table.
Oracle - Advantage of a stored procedure over a database
trigger - April 10, 2009 at 11:00 AM
Advantage of a stored procedure over a database trigger.
Stored procedure is a set of pre-compiled SQL statements, executed when it is
called in the program.
Triggers are similar to stored procedure except it is executed automatically
when any operations are occurred on the table.
Explain the difference between trigger and stored procedure.
Procedure runs only when one call them manually whereas a trigger runs when
there is any activity (insert,update,delete) on table on which the trigger is
written.
Also read
Support SQL data manipulation, provide facilities like conditional checking,
branching and looping.............
Triggers can execute every time some field in database is updated. If a field is
likely to be updated often.............
Locking protect table when several users are accessing the same table. Locking
is a concurrency control technique in oracle. It helps in data integrity while
allowing maximum..........
A cold backup is done when there is no user activity going on with the system.
Also called as offline backup, is taken when the database is not running and no
users are logged in.........
|
