Interested to Buy Any Domain ? << Click Here >> for more details...
which will fire first ? Trigger or Constraint
- 24 Answers
- 51988 Views
- i2, IBM, I also Faced
- E-Mail Answers
Answer Posted / vanujit
sequence of execution is as follows
Before statement level trigger
Before row level trigger
After row level trigger
Constraint
After statement level trigger
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
The in operator may be used if you know the exact value you want to return for at least one of the columns.
define join and explain different type of joins? : Sql dba
Explain aggregate functions are available there in sql?
What is %type in pl sql?
Why self join is used in sql?
What is the difference between a procedure and a function?
What is pl sql variable?
What are the subsets of sql?
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 are field types?
What is sql scripting?
Is inner join faster than left join?
Do prepared statements prevent sql injection?
What is difference between stored function and application function?
What are inbuilt functions in sql?
