How write a SQL statement to query the result set and display row as columns and columns as row?

In Oracle:http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:766825833740would give you a general idea about how to implement it.

How write a SQL statement to query the result set ...

TRANSFORM Count(Roll_no) AS CountOfRoll_no
SELECT Academic_Status
FROM tbl_enr_status
GROUP BY Academic_Status
PIVOT Curnt_status;

The simplest way to implement this in SQL 2000/OracleSelect * from table1Create a temp table with No of columns = No of rows in table 1No of rows = No of columns in table 1and insert the data into the temp table using a loop logic.

How write a SQL statement to query the result set and display row as columns and columns as row?