Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Rows last update Date/Time/User
In the table create two columns
last_updt_name varchar2(n)
last_updt_date date.
Populate these two fields. The time can be got from last_updat_date,
as select to_char(last_updt_date,'dd-mon-yyyy hh24:mi:ss')
from table_name
Hope this helps
Venkatesh K Received on Sat Mar 21 1998 - 00:00:00 CST
![]() |
![]() |