Hi DBAs,

I have table emp
when I EXECUTE FOLL QUERY
SQL>select * from emp;
empno ename sal deptno
1000 JAMES 1000 10
1001 BLACK 5000 30
1005 SAM 7000 20

It is showing rows in horizontal format
I want the o/p should display

1000 1001 1005
JAMES BLACK SAM
1000 5000 7000
10 30 20


WILL I GET SUCH O/P????
WAITING FOR REPLY.

Paresh