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


by
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
Originally posted by inventors inventors wrote:

Hi.. it's me inventors..
oracle 9i..
can i use commit inside of trigger..


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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net