In database class we were to type the following commands in SQL
CREATE TABLE extensions (
extension number(5) PRIMARY KEY,
department VARCHAR(20) );
CREATE TABLE employee (
SSN NUMBER(9) PRIMARY KEY,
extension NUMBER(5) references extensions,
name VARCHAR2(20),
salary number(10, 2) check (salary >= 0) not null,
startdate date
);
I was able to do this using sqlite3 in OSX.
Now I'm supposed to do the same thing using Oracle instead of SQL. I've tried installing a number of things, but can't get it to work.
What should I install.
