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....
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....
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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/
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/
ASKER
solved
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