CodingForums.com - View Single Post

Spookster · 10-22-2002, 09:32 PM

Well we can answer your question here unless you don't want us to. If not you can do a search on google for oracle forums.

But in order to help you we would need more information such as the questions i asked earlier which you didn't answer. Also when inserting data into your database the proper way would be to explicitly state which fields such as:

INSERT INTO EMP (field1, field2, field3, field4, field5, field6, field7, field8) VALUES(7512,"andreou","adasasd",7890,"10-NOV-88",1000000,NULL,30);

Your date is in the proper default format for oracle so there should not be any problem with it assuming it is set to the date datatype.

Why are you so sure the date is the problem?

10-22-2002, 09:32 PM	PM User \| #8
Spookster Supreme Overlord Join Date: May 2002 Location: Marion, IA USA Posts: 6,220 Thanks: 4 Thanked 80 Times in 79 Posts	Well we can answer your question here unless you don't want us to. If not you can do a search on google for oracle forums. But in order to help you we would need more information such as the questions i asked earlier which you didn't answer. Also when inserting data into your database the proper way would be to explicitly state which fields such as: INSERT INTO EMP (field1, field2, field3, field4, field5, field6, field7, field8) VALUES(7512,"andreou","adasasd",7890,"10-NOV-88",1000000,NULL,30); Your date is in the proper default format for oracle so there should not be any problem with it assuming it is set to the date datatype. Why are you so sure the date is the problem? __________________ Spookster CodingForums Supreme Overlord All Hail Spookster Who gave you that Ugging infraction? Yeah that's right it was me!