| Unable to inser data -ORA-00917 [message #341234] |
Sun, 17 August 2008 23:18  |
TJPokala
Messages: 17
Registered: March 2008
|
Junior Member |
|
|
can't insert thsi data ..why???
These syntax comes form Oracle 7 and I am running it in Oracle 10G.
insert into sitesvalues ( 1, 'TESA','WEMN','WEMEN',to_date('03-JUN-00','DD-MON-YY');
Error:Missing comma ORA-00917
But i can do this:
select 1, 'TESA', 'WEMN', 'WEMEN',to_date('03-JUN-00','DD-MON-YY')from dual
;
And when I do this
insert into sites values ( 1, 'TESA','WEMN','WEMEN',sysdate);
Something to do with conversions?
|
|
|
|
|
|
| Re: Unable to inser data -ORA-00917 [message #341240 is a reply to message #341238] |
Sun, 17 August 2008 23:30  |
TJPokala
Messages: 17
Registered: March 2008
|
Junior Member |
|
|
Its 2000....
And I did try this as well..>Same error
insert into sites values ( 2, 'TESA', 'WEND',
'WENDOUREE',
to_date('03-JUN-2000','DD-MON-YYYY');
is it because thsi syntax comes from oracle 7 and I am running it in 10G ...Do i need to alter some NLS_DATE_FORMAT in 10G?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
So silly!!!
