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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 08 03:45:45 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.