Exforsys

Online Training

TYpes of Trigger

This is a discussion on TYpes of Trigger within the Oracle Database forums, part of the Database category; What are the types of trigger available in Oracle. Can someone brief me on this....


Go Back   Exforsys > Database > Oracle Database

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 12-10-2006, 02:47 AM
Senior Member
 
Join Date: Apr 2006
Posts: 162
sammy is on a distinguished road
TYpes of Trigger

What are the types of trigger available in Oracle. Can someone brief me on this.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 12-12-2006, 10:14 PM
Junior Member
 
Join Date: Dec 2006
Posts: 6
nnirmalkumar is on a distinguished road
hi,

There r 12 types of trigger which can be applied to a table. + Another one more trigger also called instead of trigger which is used to update views.

Types of trigger:

After/Before

for insert/update/delete
look in for oracle online for full details with examples.

cheers
Nirmal
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Reply


Thread Tools

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

vB 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
Discuss Your Experience - Is all types of Testing followed in Development Cycle Allan Software Testing 8 08-11-2006 02:23 AM
Is it possible to implement all types of SORT using COBOL? Allan COBOL 1 06-17-2006 07:07 PM
What is the order of trigger firing rite2sekhar Oracle Tutorials 0 10-13-2004 10:37 AM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit Tech FAQ 0 06-01-2004 06:00 AM
comp.lang.eiffel Frequently Asked Questions (FAQ) Franck Arnaud Tech FAQ 0 04-17-2004 07:27 AM


All times are GMT -4. The time now is 04:57 PM.


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