Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Rows last update Date/Time/User

Re: Rows last update Date/Time/User

From: Venkatesh Krishnamoorthy <vkrishnamoorthy_at_worldnet.att.net>
Date: 1998/03/21
Message-ID: <6f20vn$g5@bgtnsc03.worldnet.att.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US