Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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?

0 Answers  


What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,


What is an exception in pl/sql?

0 Answers  


Categories