Home » SQL & PL/SQL » SQL & PL/SQL » missing Parenthesiss
missing Parenthesiss [message #1527] Thu, 09 May 2002 01:50 Go to next message
Adebayo
Messages: 5
Registered: August 2001
Junior Member
what does this error mean
UPDATE table.name SET description='aa' WHERE (dev_id=24, skill_id=44)

java.sql.SQLException: ORA-00907: missing right parenthesis

Report message to a moderator

Re: missing Parenthesiss [message #1529 is a reply to message #1527] Thu, 09 May 2002 05:43 Go to previous message
migel
Messages: 4
Registered: February 2002
Junior Member
Try this:

WHERE dev_id=24
and skill_id=44

if you want to use the parenthesiss (they are not needed)

where ( dev_id=24
and skill_id=44 )

Report message to a moderator

Previous Topic: report conversion in excel
Next Topic: Foreign Key Reference
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 07 18:11:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.