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: 4711
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: Fri Mar 24 20:51:15 CDT 2017

Total time taken to generate the page: 0.10639 seconds