Create trigger for auto incerment id and default unix datetime
Posted
by
user1804985
on Stack Overflow
See other posts from Stack Overflow
or by user1804985
Published on 2012-12-01T05:01:39Z
Indexed on
2012/12/01
5:03 UTC
Read the original article
Hit count: 116
Any one help me to create a trigger for auto increment fld_id and Unix datetime. My table field is fld_id(int),fld_date(number),fld_value(varchar2).
My insert query is
insert into table (fld_value)values('xxx');
insert into table (fld_value)values('yyy');
I need the table record like this
fld_id fld_date fld_value
1 1354357476 xxx
2 1354357478 yyy
Please help me to create this.I can't able to do this..
© Stack Overflow or respective owner
