Exforsys

Online Training

Creating trigger with after insert or update

This is a discussion on Creating trigger with after insert or update within the Oracle Database forums, part of the Database category; Hi everyone, I am new to this forum and I am looking for some help. I am trying to create ...


Go Back   Exforsys > Database > Oracle Database

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-24-2008, 05:41 PM
Junior Member
 
Join Date: Mar 2008
Posts: 1
VirginiaT is on a distinguished road
Creating trigger with after insert or update

Hi everyone,
I am new to this forum and I am looking for some help. I am trying to create a trigger. What this trigger is suppose to do is after a user insert a record or update a record I need to add a date into a column in the same table. I have heard about mutating tables on a trigger with a before insert but will this happen on an after insert or update? Can anyone give me a simple and easy example as how to do something like this?

Thank you very much for any help I can get,
Virginia
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
QTP Material kalyansantosh Software Testing 5 05-08-2008 01:52 AM
how to access other schema synonym inside a trigger mlvarma Oracle JDeveloper 2 04-18-2008 11:49 PM
WorkFlow- Not able to update a field that has join. sumita_de Siebel 3 04-29-2007 02:59 PM
vi editor FAQ (Frequently Asked Question List), Part 1/2 E. Larry Lidz Tech FAQ 0 04-19-2004 01:02 AM
[FAQ] FileMaker Pro - database for Macintosh and Windows Martin Trautmann Tech FAQ 0 04-17-2004 08:26 AM


All times are GMT -4. The time now is 12:55 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.