Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Make Output More Readable
- Thread starter jeak
- Start date
SantaMufasa
Technical User
Jeak,
When you say, "How do I change the way Oracle outputs information?", I presume you mean within SQL*Plus. When you are in SQL*Plus, we typically rely upon SQL*Plus (versus SQL) to do formatting enhancements such as spacing flourishes. To change pagesize (which means number of output lines before another page break occurs), you can say, "SQL> set pagesize <some_number>". If you "set pagesize 0", that means do not display column headings or break pages.
When you ask, "How do I change spacing...?", I need a few more clues. What kinds of spacing changes do you want. And when you say, "My tables are not readable," what is it about their appearance that does not look good? Is there so much data on a line that it wraps around and its appearance becomes confusing? When that is the case, I use as script that prints out columns of table information vertically instead of horizontally. If that solves your problem, please advise here and I'll post my "VSelect" ("Vertical Select" script.)
Dave
When you say, "How do I change the way Oracle outputs information?", I presume you mean within SQL*Plus. When you are in SQL*Plus, we typically rely upon SQL*Plus (versus SQL) to do formatting enhancements such as spacing flourishes. To change pagesize (which means number of output lines before another page break occurs), you can say, "SQL> set pagesize <some_number>". If you "set pagesize 0", that means do not display column headings or break pages.
When you ask, "How do I change spacing...?", I need a few more clues. What kinds of spacing changes do you want. And when you say, "My tables are not readable," what is it about their appearance that does not look good? Is there so much data on a line that it wraps around and its appearance becomes confusing? When that is the case, I use as script that prints out columns of table information vertically instead of horizontally. If that solves your problem, please advise here and I'll post my "VSelect" ("Vertical Select" script.)
Dave
Hi,
In general it will work best to use some report writing tool to view data from Oracle..The ability to format the output just using SqlPlus is limited and can be tedious..
There are many good reporting packages out there, or you can use something like Access with a link to your Oracle tables.
If you plan to do a lot of reporting, not just viewing the occasional output set, then investigate this type of solution.
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
In general it will work best to use some report writing tool to view data from Oracle..The ability to format the output just using SqlPlus is limited and can be tedious..
There are many good reporting packages out there, or you can use something like Access with a link to your Oracle tables.
If you plan to do a lot of reporting, not just viewing the occasional output set, then investigate this type of solution.
- Status
Similar threads
- Locked
- Question