|
|
Re: Formatting the result set [message #623522 is a reply to message #623519] |
Thu, 11 September 2014 03:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/43055.jpg) |
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
You could set the linesize higher:
But on your screen it still may look incorrect. If you spool to a file, however, it should be all right.
Edit: Littlefoot offers another nice suggestion. Formatting the columns is indeed a good idea!
MHE
[Updated on: Thu, 11 September 2014 03:44] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
Re: Formatting the result set [message #623562 is a reply to message #623527] |
Thu, 11 September 2014 07:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/d29f577f753cb4b873212fd5ed0da4cd?s=64&d=mm&r=g) |
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
nmdivya@gmail.com wrote on Thu, 11 September 2014 04:24
It seems tedious when I wanted to display more number of fields. I have to make more trial and error to get the correct format for each column to make it look like a table.
Well it may seem tedious but you have to keep in mind that your screen/window is only so wide and so can only place so many characters on a single line. And sqlplus is a simple, text-only, command-line interface, so does not deal with proportional fonts, etc.
It is no different than opening a text file in notepad and setting word-wrap on.
|
|
|