To convert the column values into a row??
I am using oracle 9i or 10g
Hi, plz help to write a single query,(not pl/sql)
to display a column that consists values
COLUMN - SNO
the result should be a row 1,2,3,4
If you are haviong trouble with homework this simple, then you are in trouble when it gets harder.
"SELECT rownum AS "COLUMN - SNO" FROM all_objects WHERE rownum <5;"
this space intentionally left blank
And what have you coded to solve this homework assignment?
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Click Here to Expand Forum to Full Width