Answer Posted / ashish
Triggers are stored procedures created in order to enforce
integrity rules in a database. A trigger is executed every
time when database modification done.
Triggers are executed automatically on occurance of one of
the data-modification operations.
A trigger is a database object directly associated with a
particular table. It fires whenever a specific
statement/type of statement is issued against that table.
The types of statements are insert,update,delete and query
statements.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is oracle used for?
How to start your 10g xe server?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is a sub query and what are the different types of subqueries?
How would you change old and new values in an insert, delete and update triggers?
 How to use an oracle sequence generator in a mapping?
How to empty your oracle recycle bin?
Explain a data segment?
What is an oracle database table?
What is materialized view in Oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to write an inner join with the where clause in oracle?
How do we represent comments in oracle?
How can we find out the duplicate values in an oracle table?
How is it different from a normal table?