| put_line statements [message #367578] |
Mon, 30 November 1998 10:35  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
