Home » SQL & PL/SQL » SQL & PL/SQL » Re: New triggers in Oracle 8i what are they
Re: New triggers in Oracle 8i what are they [message #35789] Tue, 16 October 2001 07:12 Go to next message
dana
Messages: 7
Registered: February 2001
Junior Member
i need to know the most important triggers in oracle
thanx

----------------------------------------------------------------------
Re: New triggers in Oracle 8i what are they [message #35964 is a reply to message #35789] Fri, 26 October 2001 03:19 Go to previous messageGo to next message
Pascal
Messages: 7
Registered: October 2001
Junior Member
Hi, For starters..
Now u can do a COMMIT or ROLLBACK within a Trigger!!
,but that is possible after defining the Trigger to be an AUTONOMOUS TRANSACTION by using a PRAGMA

Also SCHEMA Level Triggers like 'BEFORE DROP on Scott.SCHEMA'

And INSTEAD OF triggers which are used when u want to insert into Views.

Hope u can look for more info using those Hints

Tschüs
Kwa Heri
Bye

----------------------------------------------------------------------
Re: New triggers in Oracle 8i what are they [message #36632 is a reply to message #35789] Thu, 06 December 2001 19:31 Go to previous message
rajeswara rao g
Messages: 1
Registered: December 2001
Junior Member
if you can tell me more i will be thankful to you

----------------------------------------------------------------------
Previous Topic: Truncating a Table from SP
Next Topic: how to insert the data
Goto Forum:
  


Current Time: Thu Mar 28 11:53:12 CDT 2024