Home » SQL & PL/SQL » SQL & PL/SQL » error (windows xp, sql, oracle)
error [message #287852] Thu, 13 December 2007 16:13 Go to next message
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:
Re: error [message #287853 is a reply to message #287852] Thu, 13 December 2007 16:27 Go to previous messageGo to next message
BlackSwan
Messages: 25035
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.
Re: error [message #287902 is a reply to message #287852] Fri, 14 December 2007 00:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Clue: what is before ")"?

Regards
Michel
Re: error [message #288066 is a reply to message #287852] Fri, 14 December 2007 11:18 Go to previous messageGo to next message
taranpreet
Messages: 1
Registered: December 2007
Junior Member
check line number 2 also,,, u need to delete something
Re: error [message #288068 is a reply to message #287852] Fri, 14 December 2007 11:24 Go to previous message
BlackSwan
Messages: 25035
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.


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


Current Time: Sat Dec 03 18:25:34 CST 2016

Total time taken to generate the page: 0.07618 seconds