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

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

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

Question Posted / sonali

5 Answers
11715 Views
KPIT, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / debasis mohanty

A trigger May Not issue A TCL statement like COMMIT,ROLLBACK,SAVEPOINT.
So U Cant Write A TCL Command Inside A trigger.

Is This Answer Correct ?

10 Yes

3 No

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

Answer / 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

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

Answer / revathi

yes

Is This Answer Correct ?

3 Yes

1 No

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

Answer / vivek

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

Is This Answer Correct ?

0 Yes

0 No

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

Answer / 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

More SQL PLSQL Interview Questions

What are the different set operators available in sql?

0 Answers

What is the difference between anonymous block and named block or stored procedure?

8 Answers

What are the main features of cursor?

0 Answers

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers TCS,

How do I run sql profiler?

0 Answers

What is secondary key?

0 Answers

Which data type doesn't allow null data type?

6 Answers TCS,

How to return multiple records from procedure?

2 Answers

List different type of expressions with the example.

0 Answers

How do I view tables in sql developer?