Database Discussion

Print Page | Close Window

data base

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=26565
Printed Date: 28 March 2026 at 4:07am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: data base

Posted By: inventors
Subject: data base
Date Posted: 21 November 2008 at 8:20am

Hi.. it's me inventors..

oracle 9i..

can i use commit inside of trigger..

www.inventorstechnologies.com

-------------
inventorstechnologies

Replies:

Posted By: inventors
Date Posted: 21 November 2008 at 8:23am

any one have oracle 10g pdf....

-------------
inventorstechnologies

Posted By: vikas
Date Posted: 23 January 2009 at 1:18pm

I am not sure but i had searched it for you then i found it.try hope its ll do that.
use commit inside a trigger by using pragma_autonomous_transactions

-------------
http://www.webdesigningcompany.net/" rel="no follow - Web design
Web Design New Yk

Posted By: Gracey
Date Posted: 09 March 2009 at 8:30am

inventors wrote:

Hi.. it's me inventors..

oracle 9i..

can i use commit inside of trigger..

www.inventorstechnologies.com

Hello,

Firstly, we know what is trigger mean: A trigger (from the Dutch trekken, meaning to pull) is a lever which, when pulled by the finger, releases the hammer on a firearm. In a database, a trigger is a set of Structured Query Language ( http://searchsqlserver.techtarget.com/sDefinition/0,,sid87_gci214230,00.html" rel="nofollow - SQL ) statements that automatically "fires off" an action when a specific operation, such as changing data in a table, occurs. A trigger consists of an event (an INSERT, DELETE, or UPDATE statement issued against an associated table) and an action (the related procedure). Triggers are used to preserve data integrity by checking on or changing data in a consistent manner.

Use the CREATE TRIGGER statement to create and enable a database trigger, which is:

A stored PL/SQL block associated with a table, a schema, or the database or
An anonymous PL/SQL block or a call to a procedure implemented in PL/SQL or Java

Oracle Database automatically executes a trigger when specified conditions occur.

When you create a trigger, the database enables it automatically. You can subsequently disable and enable a trigger with the DISABLE and ENABLE clause of the ALTER TRIGGER or ALTER TABLE statement.

Thanks

Posted By: junction4seo
Date Posted: 23 June 2009 at 7:01pm

Hey I have oracle 10 pg if you want contact me.