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!newshub.sdsu.edu!elnk-nf2-pas!newsfeed.earthlink.net!stamper.news.pas.earthlink.net!stamper.news.atl.earthlink.net!newsread3.news.atl.earthlink.net.POSTED!801fd923!not-for-mail
From: "Ike" <rxv@hotmail.com>
Newsgroups: comp.databases.oracle.misc
Subject: Create trigger syntax
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <2xrYf.442$Es3.134@newsread3.news.atl.earthlink.net>
Date: Tue, 04 Apr 2006 10:04:46 GMT
NNTP-Posting-Host: 4.159.131.180
X-Complaints-To: abuse@earthlink.net
X-Trace: newsread3.news.atl.earthlink.net 1144145086 4.159.131.180 (Tue, 04 Apr 2006 03:04:46 PDT)
NNTP-Posting-Date: Tue, 04 Apr 2006 03:04:46 PDT
Organization: EarthLink Inc. -- http://www.EarthLink.net
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:126375

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