Hi Experts
when a row is getting insert i want the sysdate/time to get auto created in the table .
primary nu
emp id
skill set
created date
001
123
java
Date of record creation
I have written a query like this
insert into table_name (emp_id,skill_set) values ( empid,skillset)
but while inserting the record into table i was date to get autogenerated and insert.
How to do it…
In Schema Browser - enter sysdate in the default field or modify the table as follows…
ALTER TABLE table_name
MODIFY(created_date DEFAULT sysdate);
From: Andersun [mailto:bounce-Andersun@toadworld.com]
Sent: Friday, October 31, 2014 3:28 AM
Subject: [Toad for Oracle - Discussion Forum] insert auto date
Thread created by Andersun
Hi Experts
when a row is getting insert i want the sysdate/time to get auto created in the table .
primary nu
emp id
skill set
created date
001
123
java
Date of record creation
I have written a query like this
insert into table_name (emp_id,skill_set) values ( empid,skillset)
but while inserting the record into table i was date to get autogenerated and insert.
How to do it…
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
