Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.news.ucla.edu!newsfeed.berkeley.edu!ucberkeley!sn-xt-sjc-03!sn-xt-sjc-09!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.misc Subject: Re: Create trigger syntax Date: Tue, 04 Apr 2006 09:17:59 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1144167478.51818@yasure.drizzle.com> User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 References: <2xrYf.442$Es3.134@newsread3.news.atl.earthlink.net> In-Reply-To: <2xrYf.442$Es3.134@newsread3.news.atl.earthlink.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 13 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:126387 Ike wrote: > Can someone please show me the proper syntax to use here. I'm trying to > create a trigger on a table 'customers', to insert both the id and date_time > in a table called 'custfollow' for each row, before each insert and update. > I'm hung up really on the last part of the statement to create this trigger. > Can someone please show me how to properly construct this? Thanks, Ike Morgan's Library at www.psoug.org. Click on Table Triggers. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)