i have created a table called std_detail:

create table std_detail (ENAME VARCHAR2(30), ROLL_NO VARCHAR2(5), time date);

ENAME ROLL_NO TIME

---------------------------------------------------------------------

i want that whenever i insert into the table ,the time field should get updated according to the system date like( select sysdate from dual).

for e.g.

insert into std_detail (ename,roll_no) values( 'jeevan',09987)

then the table should look like:

ENAME ROLL_NO TIME

jeevan 09987 6/25/2008 3:17:36 PM
-----------------------------------------------------------------------

can anyone help me in this