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...

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

Answer Posted / nishi.swain@gmail.com

using pragma autonomous transaction

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many tables can you join in sql?

957


How many types of tables are there?

951


What is difference between pls_integer and integer?

952


Which one is better sql or oracle?

969


Does oracle roll back the transaction on an error?

1013


How delete a row in sql?

992


What is the difference between sum and count in sql?

986


What is date functions?

1028


How do I create an index in word?

1031


What are keys in sql?

999


What is t sql used for?

1013


What are sql objects?

1076


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1829


What is Difference Between Unique and Primary Key Constraints?

1105


What is the purpose of cursors in pl/sql?

1134