Avatar of walkerdba
walkerdba
 asked on

output

This is the output of a query ...

Can I see in a nicer way
....


EDITION_NAME
------------------------------
SYS
WRH$_EVENT_HISTOGRAM_PK
WRH$_EVENT__3831133909_84           74230          73894 INDEX PARTITION

OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S  NAMESPACE
--------- --------- ------------------- ------- - - - ----------
EDITION_NAME
------------------------------
31-DEC-12 31-DEC-12 2012-12-31:03:46:55 VALID   N N N          4



72359 rows selected.

SQL>

also page by page display....
Oracle Database

Avatar of undefined
Last Comment
walkerdba

8/22/2022 - Mon
Steve Wales

In SQLPlus you can change the default width of your output (which isn't going to help a whole lot for very wide output) from the default 80 by going

set linesize xxx

(where xxx is how wide you can go - 132, 200, whatever).

linesize can also be shortened to lines.

You can change the length of the page displayed by

set pagesize xxx

(where xxx is the height of your display and pagesize can be shortened to pages)

Also to display a "page" (based on pagesize) at a time:

set pause on

You can also do

set pause "Press Enter to contine...."

To prompt for the pressing of enter.

For extremely large output (like 70K+ rows), I often try to put the output into an Excel spreadsheet for ease of manipulation (unrelated to your question, but for wide and long output it's certainly easier to view
Gerwin Jansen

Hi, you can use the spool function to create an output file, like this:

spool <filename>
(your query)
spool off

If you want a CSV like output, you can set these options before you spool to a file:

set colsep ,
set pagesize 0
set linesize <somesize>
spool <filename>
etc.
ASKER CERTIFIED SOLUTION
Qlemo

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Geert G

if this is for browsing through data, you might want to use a data displaying tool

you could install sql developer (part of the 11 oracle client installation)
the grid displaying the data formats your columns
http://docs.oracle.com/cd/E11882_01/doc.112/e12152/intro.htm#RPTUG10100

or go for a more expensive solution like Toad for Oracle
http://www.quest.com/toad-for-oracle/
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
walkerdba

ASKER
solved