Home » SQL & PL/SQL » Client Tools » SQL +
SQL + [message #257495] Wed, 08 August 2007 08:35 Go to next message
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.
Re: SQL + [message #257498 is a reply to message #257495] Wed, 08 August 2007 08:41 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Try
set linesize 5000 (or whatever length you need up to 32K) 
 
Re: SQL + [message #257501 is a reply to message #257495] Wed, 08 August 2007 08:46 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Also
set long 8000 {or whatever}
Re: SQL + [message #257502 is a reply to message #257495] Wed, 08 August 2007 08:46 Go to previous message
webadministrator
Messages: 45
Registered: October 2005
Member
thank you a lot
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:
  


Current Time: Sun Dec 04 21:03:21 CST 2016

Total time taken to generate the page: 0.11121 seconds