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.