find out the error 'missing right parenthesis' in following code

[yashpalraghav]

create table y_employees (employee_id number primary key, first_name varchar2(20), last_name varchar2(20),ph one_number varchar2(20) unique, hire_date varchar2(20) not null, job_id varchar2(20), salary number check(salary >100),manager_i d number, department_id number foreign key references y_departments (department_id) )

[balame2004]

It seems your query is invalid. Datatype is invalid. You should specify number datatype like number(10,2). Also there is no data type like varchar2. Change it to be varchar and run. It works.

[gpl]

This is Oracle SQL, could it be moved to the right forum