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
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
What is meant by temporal data?
Can we use rowid as primary key?
What is pl sql architecture?
what is the difference between truncate and delete statement? : Transact sql
Explain correlated query work?
Can you join views in sql?
Is there a way to automate sql execution from the command-line, batch job or shell script?
explain the difference between bool, tinyint and bit. : Sql dba
How many scalar data types are supported in pl/sql?
What is the difference between left join and right join?
What is foreign key sql?
is it possible to pass an object or table to a procedure as an argument?
What are joins in sql?
what is the difference between where clause and having clause? : Sql dba