this table has many columns and only 1 record.

select * from table;

generates an unreadable list.


how can i list the record as in two columns? (column name and its value)?


i looked at UNPIVOT, but could not get it to work.


SQL> select * from table UNPIVOTE INCLUDE NULLS; ? ? ? ? ? ? ? ? ? ?
select * from table UNPIVOTE INCLUDE NULLS
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? *
ERROR at line 1:
ORA-00933: SQL command not properly ended