What is a database trigger ? Name some usages of database
trigger ?

Answer Posted / swapnareddy

Database trigger is a stored procedure that invokes
automatically when a predefined event occurs.
The usage of database trigger is to audit the data modification.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3619


What is meant by temporal data?

723


Can we use rowid as primary key?

760


What is pl sql architecture?

715


what is the difference between truncate and delete statement? : Transact sql

802


Explain correlated query work?

809


Can you join views in sql?

739


Is there a way to automate sql execution from the command-line, batch job or shell script?

763


explain the difference between bool, tinyint and bit. : Sql dba

739


How many scalar data types are supported in pl/sql?

746


What is the difference between left join and right join?

700


What is foreign key sql?

766


is it possible to pass an object or table to a procedure as an argument?

859


What are joins in sql?

741


what is the difference between where clause and having clause? : Sql dba

756