July 30th, 2012, 08:42 AM
Help with sql table
Hi i need help creating a sql table im getting error " ORA-00907: missing right parenthesis"
CREATE TABLE Campaign
(campaign_id NUMBER(5) PRIMARY KEY,
Account VARCHAR(20) NOT NULL,
Discovery VARCHAR(30) NOT NULL,
GCM_Oppty VARCHAR(10) NOT NULL,
GCM_Status VARCHAR(10) NOT NULL,
Comments VARCHAR(80) NOT NULL,
Next_Steps VARCHAR(10) NOT NULL,
HW VARCHAR(10) NOT NULL,
OS VARCHAR(10) NOT NULL,
DB VARCHAR(10) NOT NULL);
the problem is "ID" and "ID+R", i need these to conect with other sql tables
July 30th, 2012, 09:00 AM
Were did you find the ID and ID+R? Those types does not exists, at least not with MySql.
For valid (data) types you should look at the manual:
To "conect with other sql tables" I suggest you take a look at foreign keys:
If this does not help, then please explain more specific what you goal is.
July 30th, 2012, 09:08 AM
http:// s10.postimage. o r g/gx8a32phl/image.jpg
heres the picture of the database model, let me know if that helps u
July 30th, 2012, 09:15 AM
You have three tables each with a fieldname called "ID", but no data type for it?
In MySql, it is possible to create an auto-increment integer, maybe this is what you need?
Did you look at the links in my previous post?
July 30th, 2012, 11:20 AM
sanjit, please confirm, are you using mysql? or oracle?
Originally Posted by sanjit
July 30th, 2012, 12:52 PM
Im using apex so its oracle?
Originally Posted by r937
July 30th, 2012, 01:24 PM
Then you need to post in the correct forum.
Thread moved to Oracle forum.
July 30th, 2012, 02:15 PM
Same issue in Oracle forum.
Where did you get your column types of ID and (the highly unusual) ID+R?