Reputation: 21907
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
Upvotes: 0
Views: 83
Reputation: 60095
use defaults:
create table Tab (
created date default sysdate,
...
Upvotes: 2