From: Newsgroups: comp.databases.oracle.misc Subject: Re: SQLPLUS -ORA-00984 Coumn no allowed here Date: Wed, 04 Apr 2001 15:30:11 -0000 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Content-Type: text/plain Content-Disposition: inline Mime-Version: 1.0 X-Mailer: MIME-tools 4.104 (Entity 4.117) References: X-Complaints-To: newsabuse@supernews.com Lines: 42 YOU STAR, Thanks a lot. Ben nick wrote: > > > ben_knill wrote: > > > > Im new to Oracle SQLPLUS and I keep getting this error. The code is: > > > > INSERT INTO customer > > > (cust_no,cust_name,cust_add_1,cust_add_2,cust_add_city,cust_add_county,cust > > _postcode,cust_credit)values (&customer_number, &customer_name, > > &customer_Address_line_1,&Customer_Address_line_2,&Customer_city, > > &Customer_County, &customer_postcode, &Customer_credit); > > Firstly, I get a comma missing message on cust_name, after the space. > > Then I retry, removing the space and then I get the ORA-00984 error message > > > > -- > > Posted via CNET Help.com > > http://www.help.com/ > > If the customer_name,address_line1,address_line, and the rest of the > columns are VARCHAR then you would have to put them within the singel > quote.... Ex: insert into customer > values > (&customer_number,'&customer_name','&customer_address_1'); > > > -- > Posted via CNET Help.com > http://www.help.com/ -- Posted via CNET Help.com http://www.help.com/