Toad World® Forums

insert auto date


#1

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…


#2

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

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] insert auto date

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.