Setting up the example database

I'm a newbie, trying to download and open the database so I can use the examples in Mastering Oracle SQL. The best I've been able to to is copy and paste one command at a time. I was doing well creating tables and then suddenly started getting "ORA-00911: invalid character" messages on commands like:

CREATE TABLE DISPUTED_ORDERS(
ORDER_NBR NUMBER(7) NOT NULL,
CUST_NBR NUMBER(5) NOT NULL,
SALES_EMP_ID NUMBER(5) NOT NULL,
SALE_PRICE NUMBER(9,2),
ORDER_DT DATE NOT NULL,
EXPECTED_SHIP_DT DATE NOT NULL,
STATUS VARCHAR2(20),
CONSTRAINT disputed_orders_pk PRIMARY KEY (ORDER_NBR)
);

Any help? Thanks, Bill
1 person has
this question
+1
Reply