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
1
2
3
4
the result should be a row 1,2,3,4
with thanks
gms
Printable View
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
1
2
3
4
the result should be a row 1,2,3,4
with thanks
gms
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;"
.
And what have you coded to solve this homework assignment?
:rolleyes: