insert missing expression error
875882Jul 15 2011 — edited Jul 15 2011I am trying to insert data into sql plus and I keep getting this error. I am new at this and have no idea what I am doing wrong. Could someone please help!
here is the table I am inserting:
Name Null? Type
----------------------------------------- -------- ----------------------------
MANUFACTURER_ID NOT NULL NUMBER
M_NAME VARCHAR2(30)
STREET VARCHAR2(30)
CITY VARCHAR2(30)
STATE VARCHAR2(20)
COUNTRY VARCHAR2(30)
WEBSITE VARCHAR2(50)
EMAIL VARCHAR2(50)
FAX VARCHAR2(15)
I am inserting these values:
SQL> insert into manufacturer values(9185247,rollinsonlightsportaircraft,route2box186, bloomfield_in_47424, In, US, 'www.eurofox-use.com','info@eurofox-usa.com', 8123840518);
insert into manufacturer values(9185247,rollinsonlightsportaircraft,route2box186, bloomfield_in_47424, In, US, 'www.eurofox-use.com','info@eurofox-usa.com', 8123840518)
*
ERROR at line 1:
ORA-00936: missing expression
I have been working on this forever and I am just not getting it. Please help!