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


Please Help Members By Posting Answers For Below Questions

when MSQL8.0 is in market

1595


Why is a primary key important?

545


How do I start sql profiler?

555


What is inner join in sql?

584


What is a database? Explain

593






how many columns can be used for creating index? : Sql dba

516


Write a query to display the current date in sql?

511


What is self-join and what is the requirement of self-join?

632


how to add a new column to an existing table in mysql? : Sql dba

578


What is the maximum number of columns in sql table?

549


What is delete command in sql?

554


Explain correlated query work?

589


What does truncate mean in sql?

534


How can I make sql query run faster?

558


i have some prob lem to tell me about my self in interview first round ...

1700