Create trigger for auto incerment id and default unix datetime
- by user1804985
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..
