Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: syntax
CyAndrew wrote:
> PLEASE HELP ME TO FIND WHERE IS MISTAKE
> in first (DATE type) COLUMN.
>
> insert into stroj1 values ('01/01/99 10:10:10', 4,4,4,4);
The first and most obvious problem is that I have no idea what column datatype you are inserting into. But if they are not VARCHAR, NUMBER, NUMBER, NUMBER, NUMBER you have a problem. Perhaps you need to cast what appears to be a date-time into a DATE type using TO_DATE.
Daniel A. Morgan Received on Mon Jul 23 2001 - 16:18:24 CDT
![]() |
![]() |