i create a table emp in oracle as below
create table emp(eid int,ename varchar2(30),esal long,edoj date);
when i insert data in this table it is showing problem in date datatype
how can i handle this
plz assist me ....
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abhay ShankerPosted Mar 25, 2014, 9:52 AM
INSERT INTO emp VALUES(1,Vipin,50000,TO_TIMESTAMP('27.09.2012 01:12:12.3456','DD.MM.YYYY HH24:MI:SSXFF'));
Vipin TyagiPosted Mar 25, 2014, 11:15 AM