IF i write before / after insert / update trigger and i do
rollback what will happen?
Answer Posted / ankit sinha
But if put a autonomous transaction with a rollback i think
we can do it ..
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is a schema? How is it useful in sql servers?
what is sub-query? : Transact sql
What are triggers in sql?
Explain what is table in a database?
what is uncommittable transactions? : Transact sql
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
what is union, minus and interact commands? : Sql dba
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
Is left join inner or outer?
Mention what does the hierarchical profiler does?
What is foreign key sql?
What is a primary key sql?
Is left join faster than join?
what is an extent ? : Sql dba
Is sql database free?