Oracle SQL*PLUS

I have just basic question on SQL PLUS. Is there a way in SQL Plus to change the display when a query or view is run? It all runs together on result sets that return lots of information. Thanks.
dodgerfanAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
there are lots of formatting commands in sql*plus.

you can adjust pagesize, linesize, etc.

Check here
http://download.oracle.com/docs/cd/E11882_01/server.112/e16604/toc.htm

in particular chapter 6  on formatting and chapter 12 for the complete command reference

if you have a specific example I can help with that
0
 
Alex MatzingerConnect With a Mentor Database AdministratorCommented:
You can set the page size using set pagesize <#>.  You can also change the column widths of the query using set column <name> a#.   Also extending the line might help as well. Try set linesize # for thar
0
 
Darius GhassemCommented:
Sqlplus is great but there are tools as well if you want to use a GUI version without having to set the parameters above. You can use the free tools like SQLDeveloper and SQLTools.
0
 
dodgerfanAuthor Commented:
Thanks for the help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.