Can't get this insert right? [message #448929] |
Thu, 25 March 2010 19:12  |
vandorin
Messages: 1 Registered: March 2010
|
Junior Member |
|
|
Hello, I'm trying to insert data into a table, but can't seem to get the actual code right, when I put it in, it tells me that there is a comma missing, can anyone help me? Here is the code I have that is giving me the error:
INSERT INTO Orders VALUES('00001', 'c001', 'ca01', '20.5', TO_DATE('12032009', 'DDMMYYYY');
|
|
|
Re: Can't get this insert right? [message #448930 is a reply to message #448929] |
Thu, 25 March 2010 19:31   |
 |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
vandorin wrote on Thu, 25 March 2010 17:12Hello, I'm trying to insert data into a table, but can't seem to get the actual code right, when I put it in, it tells me that there is a comma missing, can anyone help me? Here is the code I have that is giving me the error:
INSERT INTO Orders VALUES('00001', 'c001', 'ca01', '20.5', TO_DATE('12032009', 'DDMMYYYY');
PROGRAMMING 101 basic tenant is quotes must occur in pairs & for every opening parenthesis a closing parenthesis must exist.
|
|
|
|
|
|