What is trigger ?

Answer Posted / piyush

Triggers are those procedures written in PL/SQL that fire whenever one of the following operation occur, DML statements on a particular schema object, DDL statements issued within a schema or database, user log on or log off events, server errors, database startup, or instance shutdown.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a view using data from another view?

728


What are different types of statement?

667


Can truncate be rolled back?

701


How to change a login name in ms sql server?

705


How to count rows with the count(*) function in ms sql server?

723






What is equi join with example?

720


what is blocking? : Sql server database administration

714


what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

718


Can you type more than one query in the query editor screen at the same time?

771


What is query and its types?

683


What is the maximum row of a size?

766


List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

175


How to retrieve error messages using odbc_errormsg()?

724


Explain what is the purpose of sql profiler in sql server?

741


What are sp_configure commands and set commands?

719