Re: SQLPLUS -ORA-00984 Coumn no allowed here

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/