OraFAQ Forum: Client Tools

Home » Other » Client Tools » SQL +

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

SQL + [message #257495]

Wed, 08 August 2007 08:35

webadministrator
Messages: 45
Registered: October 2005

Member

Hello,
im trying to write a query in SQL + (or SQL worksheet) that gives me as a result the code of the class and the comment.
the comment is very long so i am not getting the full sentence. is there a way to fix it?

Thank you.

Report message to a moderator

Re: SQL + [message #257498 is a reply to message #257495]

Wed, 08 August 2007 08:41

MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA

Senior Member

Try

set linesize 5000 (or whatever length you need up to 32K)

Report message to a moderator

Re: SQL + [message #257501 is a reply to message #257495]

Wed, 08 August 2007 08:46

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Also

set long 8000 {or whatever}

Report message to a moderator

Re: SQL + [message #257502 is a reply to message #257495]

Wed, 08 August 2007 08:46

webadministrator
Messages: 45
Registered: October 2005

Member

thank you a lot

Report message to a moderator

Previous Topic:	disabling sqlplus output
Next Topic:	sqlplus, how to send error messages to stdout when set feedback is off and spooling to file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 16:38:58 CST 2024