getting ORA-00911: invalid character if I try to insert multiple records
886306Sep 5 2011 — edited Sep 6 2011SQL script:
Create table Customers
(Customer# NUMBER(4) PRIMARY KEY,
LastName VARCHAR2(10),
FirstName VARCHAR2(10),
Address VARCHAR2(20),
City VARCHAR2(12),
State VARCHAR2(2),
Zip VARCHAR2(5),
Referred NUMBER(4));
INSERT INTO CUSTOMERS
VALUES (1001, 'MORALES', 'BONITA', 'P.O. BOX 651', 'EASTPOINT', 'FL', '32328', NULL);
INSERT INTO CUSTOMERS
VALUES (1002, 'THOMPSON', 'RYAN', 'P.O. BOX 9835', 'SANTA MONICA', 'CA', '90404', NULL);
INSERT INTO CUSTOMERS
VALUES (1003, 'SMITH', 'LEILA', 'P.O. BOX 66', 'TALLAHASSEE', 'FL', '32306', NULL);
INSERT INTO CUSTOMERS
VALUES (1004, 'PIERSON', 'THOMAS', '69821 SOUTH AVENUE', 'BOISE', 'ID', '83707', NULL);
INSERT INTO CUSTOMERS
VALUES (1005, 'GIRARD', 'CINDY', 'P.O. BOX 851', 'SEATTLE', 'WA', '98115', NULL);
INSERT INTO CUSTOMERS
VALUES (1006, 'CRUZ', 'MESHIA', '82 DIRT ROAD', 'ALBANY', 'NY', '12211', NULL);
I keep getting ORA-00911 if I try and run multiple lines at once. If I run the create table code by itself, it works, if I enter One INSERT command, it works, but if I try and run two INSERT commands, it fails. This is a script that my lecturer handed out to everyone, it works fine in the hosted environment we log into on campus, but when I try and run it in Oracle10 installed on my home Win7 machine, it complains. Commands were copied directly from a Notepad file, and I also tried typing in two lines of INSERT commands directly into the SQL web interface, but it always throws errors if I try and INSERT two rows of data at a time