on 01-14-2011 1:23 PM
Hi All,
I was trying display the result of the select * from v$log.But there seems to be a formatting with the column width.I tried setting using column <column name > format a10 but it doesnt work.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
-
-
-
-
-
--- -
FIRST_CHANGE# FIRST_TIME
-
-
1 1 1129 262144000 2 YES INACTIVE
5506347083 14-JAN-11
2 1 1130 262144000 2 YES INACTIVE
5506397190 14-JAN-11
3 1 1131 262144000 2 NO CURRENT
5506478936 14-JAN-11
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
-
-
-
-
-
--- -
FIRST_CHANGE# FIRST_TIME
-
-
4 1 1128 262144000 2 YES INACTIVE
5506109258 13-JAN-11
Can anyone help me with formatting the display.Thanks.
Try
set pages 50 lines 120
col <col name> form a30
.....
select * from v$log
You may like to set the following before query on v$log:
alter session set nls_date_format='dd.mm.yy hh24:mi:ss';
Regards
Audun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.