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
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.
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.
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