By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,574 Members | 1,968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,574 IT Pros & Developers. It's quick & easy.

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

P: 1
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
Share this Question
Share on Google+
2 Replies


100+
P: 142
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+
P: 152
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.