OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » error (windows xp, sql, oracle)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error [message #287852]

Thu, 13 December 2007 16:13

afsheen_87
Messages: 1
Registered: December 2007

Junior Member

hi

ive looked at the faq already and tried to resolve the error but i havent been able to.. it seems fine to me.. there is no missing bracket or anything.. could you help me with this please. thanx

Error starting at line 1 in command:
CREATE TABLE Genre
(Genre_ID number(9),
CONSTRAINT genre_id_pk PRIMARY KEY,
Genre_Type varchar2(15)
CONSTRAINT genre_type_nn NOT NULL,
)
Error at Command Line:3 Column:34
Error report:
SQL Error: ORA-00906: missing left parenthesis
00906. 00000 - "missing left parenthesis"
*Cause:
*Action:

Report message to a moderator

Re: error [message #287853 is a reply to message #287852]

Thu, 13 December 2007 16:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You will NOT get syntax errors when what you write conforms to the CREATE TABLE syntax as contained in URL below.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7002.htm#sthref7382

I do not believe "CONSTRAINT" is valid within the CREATE TABLE statement as you attempted to use it.

Report message to a moderator

Re: error [message #287902 is a reply to message #287852]

Fri, 14 December 2007 00:38

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Clue: what is before ")"?

Regards
Michel

Report message to a moderator

Re: error [message #288066 is a reply to message #287852]

Fri, 14 December 2007 11:18

taranpreet
Messages: 1
Registered: December 2007

Junior Member

check line number 2 also,,, u need to delete something

Report message to a moderator

Re: error [message #288068 is a reply to message #287852]

Fri, 14 December 2007 11:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

U is not a member of this forum

From http://www.orafaq.com/forum/t/88153/0/, it says...

Quote:

Abbreviations like "U", "Ur", "U r", "Plz", "prb", "qry" especially tend to get on people's nerves.

IM speak

Instant Messager language, like the (non-exhaustive) list below

u = you

ur = you are

any1 = anyone

gr8 = great

pls/plz = please (especially avoid this in topic titles)

urgnt = urgent (especially avoid this in topic titles)

wrt = write

i = I

im = I am

is not appreciated:
It is hard to read.
It is unprofessional.
It doesn't show much respect towards your fellow forum members.

Report message to a moderator

Previous Topic:	address query
Next Topic:	how to select a non-group by value from a group by clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 26 10:23:42 CDT 2025