| what's wrong with this syntax [message #130] |
Wed, 16 January 2002 20:46  |
may chua
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
CREATE TABLE userparams(
sect varchar(255) NOT NULL,
key varchar(255) NOT NULL,
id int NOT NULL,
pro varchar(3) NOT NULL,
value varchar(255) NULL,
CONSTRAINT userparamsidx1 PRIMARY KEY NONCLUSTERED (sect,key,id,pro))
I wrote this SQL statement in the oracle SQLPlus and error returned was "ORA-00906: missing left parenthesis". Any idea what's wrong with the syntax?
I have checked that the number of parenthesis match up.
thanks.
|
|
|
|
| Re: what's wrong with this syntax [message #132 is a reply to message #130] |
Thu, 17 January 2002 00:38  |
Satish Shrikhande
Messages: 167
Registered: October 2001
|
Senior Member |
|
|
Try this ..
CREATE TABLE userparams(
sect varchar(255) NOT NULL,
key varchar(255) NOT NULL,
id int NOT NULL,
pro varchar(3) NOT NULL,
value varchar(255) NULL,
CONSTRAINT userparamsidx1 PRIMARY KEY(sect,key,id,pro))
by default it's noncluster
|
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
