Answer Posted / abhisek pattnaik
Trigger is a type of programme which is automatically
executed when ever a DML operation is made on a perticular
table.
Trigger is identical with procedure but the basic
difference between them is procedure is explicitly created
& executed by the user where as trigger is explicitly
created but implicitly fired or executed when ever a DML
operation is made.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between online and offline backups?
How to define a variable to match a table column data type?
Explain joins in oracle?
Explain coalesce function?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How view is different from a table?
Is a rollback possible to any savepoint?
How to loop through data rows in the implicit cursor?
What is proxy method?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is hash cluster in oracle?
How to create a new view in oracle?
In oracle there is column command, how will you explain that?
How to export your connection information to a file?
What is a static data dictionary in oracle?