?
Solved

output

Posted on 2012-12-31
5
Medium Priority
?
371 Views
Last Modified: 2013-01-16
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....
0
Comment
Question by:walkerdba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 22

Expert Comment

by:Steve Wales
ID: 38733999
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
0
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 38734545
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.
0
 
LVL 70

Accepted Solution

by:
Qlemo earned 2000 total points
ID: 38734592
In addition to above, sqlplus has pretty-printing capabilities. You have to describe columns, their width and type. For details look at the COLUMN keyword in http://docs.oracle.com/cd/B10501_01/server.920/a90842/ch13.htm#1007781 .
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 38735051
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/
0
 

Author Closing Comment

by:walkerdba
ID: 38784010
solved
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question