Home » RDBMS Server » Networking and Gateways » put_line statements
put_line statements [message #367578] Mon, 30 November 1998 10:35 Go to next message
Ravi Sankar S.
Messages: 2
Registered: November 1998
Junior Member
How I can use this statement in a procedure ?,
to display the values of a column before and after while updating each row.
Re: put_line statements [message #367586 is a reply to message #367578] Sat, 09 January 1999 04:24 Go to previous message
Sean Miller
Messages: 12
Registered: December 1998
Junior Member
Hi Ravi,

You could put a trigger on the table you are updating, which could use UTL_FILE to write to a flat file...

Within a trigger you can access the old and new values with :old.column and :new.column.

Hope this helps,

Sean
Previous Topic: sql*net connection
Next Topic: SQL*NET V2 for DOS
Goto Forum:
  


Current Time: Tue Feb 27 11:46:06 CST 2024