-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|