Hi guys
I newly started learning oracle.I'm working on my assignment and I'm stuck in this step because of a silly error and I'm sure of my syntax. It looks fine to me but I get this error: ORA-00907: missing right parenthesis
This is the command:
CREATE TABLE WORKER (
Wkr_id int (4),
Name varchar(50),
Hire_date date,
Wage_rate char(10),
Area_ID char(3) references AREA);
It locates the error in line 2 >>
SQL> CREATE TABLE WORKER (
2 Wkr_id int (4),
3 Name varchar(50),
4 Hire_date date,
5 Wage_rate char(10),
6 Area_ID char(3) references AREA)
Wkr_id int (4),
*
ERROR at line 2:
ORA-00907: missing right parenthesis
How can I avoid this???