473,396 Members | 2,013 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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
2 2310
balame2004
142 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
gpl
152 100+
This is Oracle SQL, could it be moved to the right forum
Dec 1 '08 #3

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

Similar topics

7
by: BWGames | last post by:
Can someone tell me whats up with this code please? $update_query = "UPDATE users SET creditremaining = creditremaining - " . $_REQUEST . "WHERE mobilenumber = " . $_REQUEST . ""; where...
0
by: chenyu468 | last post by:
Hi, I am using (vc++) of vs.net 2003 for development. In the source code, there are too many right parenthesis in one section. I want to test which left parenthesis for one specified parenthesis....
9
by: Ben Midgley | last post by:
Please have a look at the code below My problem is the error message "Nonportable pointer conversion", so far as I can tell there is no pointer conversion occuring here so I am assuming it is...
67
by: PC Datasheet | last post by:
Transaction data is given with date ranges: Beginning End 4/1/06 4/4/06 4/7/06 4/11/06 4/14/06 4/17/06 4/18/06 4/21/06 426/06 ...
1
by: Phil Powell | last post by:
<input type="submit" name="delete_student" value="Delete Applicant" onClick="setSubmitVal(this); return willDeleteApplicant('O'Connor, Kerry B');"> This HTML tag causes Javascript errors in...
1
by: vmoreau | last post by:
I have a text and I need to find a Word that are not enclosed in paranthesis. Can it be done with a regex? Is someone could help me? I am not familar with regex... Example looking for WORD:...
18
by: Bill | last post by:
I'm getting a syntax error on line 18 of this code and I don't see a missing ";". Does anyone else see it? #include < stdio.h> void main() { FILE *fp; int i; int CharString;
3
by: Thakur vikas | last post by:
when we run the query then we got ": (Error): ORA-00907: missing right parenthesis" what may be the error?
1
by: ozarka | last post by:
This select statement works and gives me True/False in RC33 column however the second statement gives me following error. Any idea? odbc--call failed. ora-00907: missing right parenthesis -...
4
by: dbrother | last post by:
Hello All, I've been plugging away at testing some VBA SQL that executes when a user clicks a button from a 'custom query' form. The user has lots of options as to what parameters should be...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.