IF i write before / after insert / update trigger and i do
rollback what will happen?

Answer Posted / vivek

The data whatever inserted/updated will be rollback once issue rollback

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cte sql?

511


What is percent sign in sql?

711


What packages(if any) has oracle provided for use by developers?

5013


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

609


Explain ddl statements in pl/sql?

570






What is trigger types of trigger?

546


What is difference between stored function and application function?

590


If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3543


How to fetch alternate records from a table?

673


What is sqlcommand?

546


What is restrict in sql?

551


Is primary key clustered index?

511


Is inner join same as self join?

572


What is input buffer in sql*plus?

632


How to order siblings in oracle hierarchy queries?

593