OraFAQ Forum: Client Tools » SQL Plus command length

Home » Other » Client Tools » SQL Plus command length

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

SQL Plus command length [message #281815]

Mon, 19 November 2007 07:00

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

Sql*Plus Release 10.2.0.2
When i try to enter query in separate lines e.g
>select abc,def
>from ad
>where.......
The above statement works whereas if i give the same in a single line it gives SP2-0734: unknown command beginning
This is a long query about 300 characters.

Thanks

Report message to a moderator

Re: SQL Plus command length [message #281818 is a reply to message #281815]

Mon, 19 November 2007 07:11

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

Senior Member
Account Moderator

1/ The correct forum is SQL Client Tools and not SQL or PL/SQL this neither a SQL nor PL/SQL question, doesn't it?

2/ What does the documentation about SQL*Plus says?

3/ What is your OS? If it is Windows, do you use sqlplus.exe or sqlplusw.exe?

4/ Copy and paste your screen does not just explain what you see.

Regards
Michel

Report message to a moderator

Re: SQL Plus command length [message #281827 is a reply to message #281815]

Mon, 19 November 2007 07:50

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

It was a mistake i should have posted it at SQL Client Tools,i don't find a way to edit or move this topic.I would appreciate if i am allowed to move this topic to the correct forum.
Thanks

Report message to a moderator