467,917 Members | 1,434 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,917 developers. It's quick & easy.

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

create table y_employees (employee_id number primary key, first_name varchar2(20), last_name varchar2(20),phone_number varchar2(20) unique, hire_date varchar2(20) not null, job_id varchar2(20), salary number check(salary >100),manager_id number, department_id number foreign key references y_departments (department_id) )
Nov 28 '08 #1
  • viewed: 2127
Share:
2 Replies
100+
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.
Nov 28 '08 #2
100+
gpl
This is Oracle SQL, could it be moved to the right forum
Dec 1 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by BWGames | last post: by
reply views Thread by chenyu468 | last post: by
67 posts views Thread by PC Datasheet | last post: by
1 post views Thread by Phil Powell | last post: by
18 posts views Thread by Bill | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.