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 you use a commit statement within a database trigger?

Answer Posted / charan

Hi this is charan...
Actually Not allowed TCL commands in trigger...but it is possible we are not use directly these commands...to over come this problem oracle introduced one concept is called "Autonomous Transactions" .through autonomous transaction we are using tcl commands in Trigger concept....This is according to my knowledge

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I combine multiple rows into a comma-delimited list in oracle?

1006


How many types of segments in Oracle?

1022


Which is better Oracle or MS SQL? Why?

6272


What privilege is needed for a user to insert rows to tables in another schema?

963


Explain table?

1072


What is ADDM Advisor in Oracle?

1122


How do I escape a reserved word in oracle?

1139


What is varray?

1044


what are the advantages of running a database in archive log mode?

2149


How to create a new table by selecting rows from another table?

1027


What is a select query statement in oracle?

906


Please explain joins in oracle?

1013


What are the advantages of oracle 12c?

1131


What is the string concatenation operator in oracle?

1103


Explain the use of analyse option in exp command.

1073