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
How to revoke create session privilege from a user in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
How many types of tables supported by oracle?
Describe varray?
Can we insert data in view oracle?
Explain an extent?
What is the relation of a user account and a schema?
Are truncate and delete commands same? If so why?
Why do you use stored procedures and state some of its disadvantages?
Why use resource manager in Oracle?
What is a system tablespace?
What privilege is needed for a user to query tables in another schema?
What is transport network substrate (tns) in oracle?
What are transaction isolation levels supported by oracle?
What are the different types of synonyms?