>>>> 2013/04/24 09:06 -0700, Rajeev Prasad >>>>
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
<<<<<<<<
>From MySQL client, if started with flag '-G':
select * from table
ego
For the same program there is flag '--auto-vertical-output'.
But it seems you are using Oracle; this is MySQL list.
In any case, you wrote both 'UNPIVOT' and 'UNPIVOTE'; I suspect the former is
better.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
