Home » SQL & PL/SQL » Client Tools » Output containing more than 80 chars per line (Oracle 10g , XP)
Output containing more than 80 chars per line [message #378796] Thu, 01 January 2009 23:11 Go to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Hello friends,

I am having problem with output shown in SQL *Plus.
Many times output of the query comes with the row containing more than 80 columns.
And at that time it becomes confusing to understand the output.

So is there any way to display whole row in one single line?

regards,
Delna
Re: Output containing more than 80 chars per line [message #378798 is a reply to message #378796] Thu, 01 January 2009 23:39 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
set linesize nnnnn

Check the SQLPlus manual at tahiti.oracle.com for more handy settings.
Re: Output containing more than 80 chars per line [message #378807 is a reply to message #378798] Fri, 02 January 2009 00:11 Go to previous message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Thanks Frank sir.

I used SET LINESIZE statement.

regards,
Delna
Previous Topic: Cost is not displaying in plsql developer tool
Next Topic: How to make Client
Goto Forum:
  


Current Time: Sat Dec 03 16:26:42 CST 2016

Total time taken to generate the page: 0.14295 seconds