Clicky

What is the best way to see this out put in a nicer way




SQL> SQL> select * from v$log where status='CURRENT';

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------------- ------------- --------- ------------ ---------
         3          1          3  104857600        512          1 NO
CURRENT                  62915 25-NOV-11   2.8147E+14


SQL>

asked 11/25/2011 06:36

nobleit's gravatar image

nobleit ♦♦


2 Answers:
I am assuming you are using SQL*Plus.

There are many options that will affect the layout of the results.  One that is very useful is the linesize option than controls the length of the lines before they 'wrap' like in your example.  eg.

SET LINESIZE 120


some other options can be seen in this article http://www.adp-gmbh.ch/ora/sqlplus/beautify.html
link

answered

lwadwell's gravatar image

lwadwell

You can format your SQL PLUS by setting :

SQL> set wrap off;
SQL> SET linesize 132; OR 120 (as per earlier post ).


But for more information you can check all the setting by giving :

SQL> show all ;

Just try ..and check if you want to know more ..
link

answered 2011-11-25 at 15:11:46

slobaray's gravatar image

slobaray

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×10

Asked: 11/25/2011 06:36

Seen: 237 times

Last updated: 12/09/2011 05:01