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: insert on oracle db question

Re: insert on oracle db question

From: Anurag Varma <avoracle_at_gmail.com>
Date: 14 Mar 2006 13:28:45 -0800
Message-ID: <1142371725.782854.269580@p10g2000cwp.googlegroups.com>

Ok .. Lets see if you spot the problem in this code:

ORA92> create table vegetables (name varchar2(40));

Table created.

ORA92> insert into vegetables (name) values (SPINACH); insert into vegetables (name) values (SPINACH)

                                                         *
ERROR at line 1:
ORA-00984: column not allowed here

<The error is on "SPINACH">

HTH Anurag Received on Tue Mar 14 2006 - 15:28:45 CST

Original text of this message

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