Home » SQL & PL/SQL » SQL & PL/SQL » what's wrong with this syntax
what's wrong with this syntax [message #130] Wed, 16 January 2002 20:46 Go to next message
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 Go to previous messageGo to next message
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
Re: what's wrong with this syntax [message #145 is a reply to message #130] Fri, 18 January 2002 10:34 Go to previous message
vk
Messages: 13
Registered: December 2001
Junior Member
don't specify NONCLUSTERED. It is wrong syntax
Previous Topic: Triggers
Next Topic: How to populate a table
Goto Forum:
  


Current Time: Tue Jul 14 11:50:08 CDT 2020