OraFAQ Forum: SQL & PL/SQL » missing SELECT keyword error

Home » SQL & PL/SQL » SQL & PL/SQL » missing SELECT keyword error

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

missing SELECT keyword error [message #4399]

Thu, 05 December 2002 01:24

liglin
Messages: 2
Registered: December 2002

Junior Member

What is wrong with this SQL?

SQL> start testit
INSERT INTO Calling_Card7('TEST02',234,234,234,52345)
*
ERROR at line 1:
ORA-00928: missing SELECT keyword

Thanks, Liglin

Commit complete.

Report message to a moderator

Re: missing SELECT keyword error [message #4405 is a reply to message #4399]

Thu, 05 December 2002 04:11

Kavitha
Messages: 40
Registered: December 1999

Member

Hi,

You missed the values keyword.

Try this:
INSERT INTO Calling_Card7 values('TEST02',234,234,234,52345)

Report message to a moderator

Re: missing SELECT keyword error [message #4431 is a reply to message #4399]

Sun, 08 December 2002 19:21

liglin
Messages: 2
Registered: December 2002

Junior Member

oops...

thank you very much!

Liglin

Report message to a moderator

Previous Topic:	Error with this populate script. Any Insight?
Next Topic:	PL/SQL output formatting question/problem...please help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 09:03:16 CDT 2024