IF i write before / after insert / update trigger and i do
rollback what will happen?
Answer Posted / abhijit
we cant use tcl commands in trigger,,,
if we call procedure in trigger then we can use pragma autonomous transaction for tcl
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
when MSQL8.0 is in market
Why is a primary key important?
How do I start sql profiler?
What is inner join in sql?
What is a database? Explain
how many columns can be used for creating index? : Sql dba
Write a query to display the current date in sql?
What is self-join and what is the requirement of self-join?
how to add a new column to an existing table in mysql? : Sql dba
What is the maximum number of columns in sql table?
What is delete command in sql?
Explain correlated query work?
What does truncate mean in sql?
How can I make sql query run faster?
i have some prob lem to tell me about my self in interview first round ...