Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: syntax

Re: syntax

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Mon, 23 Jul 2001 14:18:24 -0700
Message-ID: <3B5C94A0.B982C76F@attws.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US