views:

24

answers:

1

I've an existing table with 'creation time' column in one of the table.

I want the value of it to be generated automatically by the Oracle when the row gets inserted, instead of me populating in the application.

Thank You

+2  A: 

use defaults:

create table Tab (
   created date default sysdate,
...
Andrey