[prev in list] [next in list] [prev in thread] [next in thread]
List: odtug-sqlplus-l
Subject: RE: Triggersintax
From: "Satish" <satish () medicomsoft ! com>
Date: 2002-07-13 13:53:41
[Download RAW message or body]
Dear Ranga,
Do u want to create a log of the transaction on table1 or u want to
replicate the data of table1 into table2. If u want to replicate the data
than u can write a database trigger on table1 using After insert update and
delete clause... In the body of the trigger check if inserting..... updating
.... deleting... and do explicit insert, update and delete in the table2...
If u want to create log than for each transaction done on table1, u can
insert the records in table2 with some flag to identify the type of
transaction.
With best regds
Satish
-----Original Message-----
From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of ranga keerthi
Sent: Saturday, July 13, 2002 5:28 PM
To: Multiple recipients of list ODTUG-SQLPLUS-L
Subject: RE: Triggersintax
Dear Satish
How To Create A Trigger
such that the data inserted/updated/deleted from the table1( ie car)
has to be copied on to a new table2 ( ie data) Atuomatically / Dynamically
the fields are
car(carid,make,model,year,weight,family);
data(carid,make,modle,year,family);
regards
ranganath
bangalore
----------------------------------------------------------------------------
--
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 5.00.3103.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=647062513-13072002>Dear
Ranga,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=647062513-13072002> Do u want to create a log of the
transaction on table1 or u want to replicate the data of table1 into table2. If
u want to replicate the data than u can write a database trigger on table1 using
After insert update and delete clause... In the body of the trigger check if
inserting..... updating .... deleting... and do explicit insert, update and
delete in the table2...</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=647062513-13072002> If u want to create log than for
each transaction done on table1, u can insert the records in table2 with some
flag to identify the type of transaction.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=647062513-13072002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=647062513-13072002>With
best regds</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=647062513-13072002>Satish</SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> root@fatcity.com
[mailto:root@fatcity.com]<B>On Behalf Of </B>ranga keerthi<BR><B>Sent:</B>
Saturday, July 13, 2002 5:28 PM<BR><B>To:</B> Multiple recipients of list
ODTUG-SQLPLUS-L<BR><B>Subject:</B> RE: Triggersintax<BR><BR></DIV></FONT>
<P>Dear Satish
<P>How To Create A Trigger
<P>such that the data inserted/updated/deleted from the table1( ie car)
<P>has to be copied on to a new table2 ( ie data) Atuomatically / Dynamically
<P>the fields are
<P>car(carid,make,model,year,weight,family);
<P>data(carid,make,modle,year,family);
<P>regards
<P>ranganath
<BLOCKQUOTE
style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">bangalore</BLOCKQUOTE>
<P><BR>
<HR SIZE=1>
<B>Do You Yahoo!?</B><BR><A
href="$rd_url/welcome/?http://autos.yahoo.com/">Yahoo! Autos</A> - Get free
new car price quotes</BLOCKQUOTE></BODY></HTML>
Thanks to everyone for making ODTUG 2002 a great success! Plan now
for next year's conference: Loews Miami Beach, Florida, June 22-27, 2003.
--
Author: Satish
INET: satish@medicomsoft.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic