Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-00984 while inserting data?
Just to clarify the previous answers, Oracle uses single quotes rather than
double quotes for strings.
"Hemant Shah" <shah_at_typhoon.xnet.com> wrote in message
news:blhb2f$jvo$1_at_flood.xnet.com...
>
> Folks,
>
> I am getting ORA-00984 while inserting data into the table. What am i
doing
> wrong:
>
>
> SQL> create table shahtst
> 2 (KEY0 CHAR (14), KEY1 CHAR (26 ))
> 3 TABLESPACE HARTTST1_DATA02
> 4 PCTFREE 10 PCTUSED 70
> 5 INITRANS 1 MAXTRANS 255
> 6 LOGGING;
>
> Table created.
>
> SQL> describe shahtst
> Name Null? Type
> ----------------------------------------- -------- ----------------------