开发者

Automatically generate value for a column in database

开发者 https://www.devze.com 2023-01-15 15:45 出处:网络
I\'ve an existing table with \'creation time\' column in one of the table. I want the value of it to be generated auto开发者_JS百科matically by the Oracle when the row gets inserted, instead of me p

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

I want the value of it to be generated auto开发者_JS百科matically by the Oracle when the row gets inserted, instead of me populating in the application.

Thank You


use defaults:

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

精彩评论

暂无评论...
验证码 换一张
取 消