using pragma autonomous transaction

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

Question Posted / nishi.swain@gmail.com

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is trigger in pl sql?

1043

What is the use of function in sql?

1143

Is sql low level language?

1063

What is attribute indicator in pl sql?

1059

How global cursor can be declare with dynamic trigger ?

2268

What is delimiter in pl sql?

1095

How to select random rows from a table?

1127

How to run pl sql program in mysql?

1066

What are the types of join and explain each?

1097

What are the sql aggregate functions?

1181

What is the process of debugging?

1121

What is full form of rtm?

1050

What is primary and foreign key?

1114

How do I save the results of sql query in a file?

1010

Can you have more than one key in a database?

986