jai
jai

Reputation: 21907

Automatically generate value for a column in database

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

Answers (1)

Andrey
Andrey

Reputation: 60095

use defaults:

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

Upvotes: 2

Related Questions