January 7, 2004 at 3:09 am
how to create a triggers and runs in pl/sql.
when and where will the trigger will activate
January 7, 2004 at 3:31 am
You mean T-SQL?
If you're looking for triggers in SQL Server take a look at CREATE TRIGGER in Books Online.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
August 27, 2008 at 3:09 am
Normally Trigger is created for an update, insert or delete event. And then it is bind with a table (object) on which it is required. And it is automatically invoked on mentioned event. To know more for creating trigger you may visit my blog post http://dbdigger.blogspot.com/2008_08_01_archive.html#5490178201922101014
DBDigger Microsoft Data Platform Consultancy.
August 27, 2008 at 7:13 am
If you really do mean PL/SQL, you'll have to try an Oracle forum. This one is for Microsoft SQL.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply