dbaplusplus_at_hotmail.com wrote in
news:1129166818.112886.64850_at_g43g2000cwa.googlegroups.com:
> I am using Oracle 9.2.0.x and Oracle 10.1.0.3 on HP UNIX 11.x. There
> used to be a freeware script on internet which lets you show rows of a
> table in a vertical fashion:
>
> row 1
> col1: val1
> col2: val2
> col3: valu3
> col4: val4
>
>
> ..
>
>
>
> row 2
>
> Script will support many of the common cloumn types such as integer,
> varchar2, date but not all.
>
> When I use sqlplus, it prints rows in a "horizontal fashion;
> val1 val2 val3 val4
> val1 val2 val3 val4
>
> and I do not want to use sqlplus format command for each table.
>
>
> Anyone knows a link to such script.
>
visit http://asktom.oracle.com
and do a key word search on "PIVOT TABLE"
Received on Wed Oct 12 2005 - 20:47:00 CDT
