Home » SQL & PL/SQL » Client Tools » Matrix out put
Matrix out put [message #247067] Sat, 23 June 2007 08:52 Go to next message
oracle.kranthi
Messages: 1
Registered: June 2007
Location: NewYork
Junior Member
Hi all,

I need an sql output like this

Deptno Ename
-----------------
10..........CLARK
.......... KING
.......... MILLER
20..........JONES
.......... FORD
.......... ADAMS
..
Re: Matrix out put [message #247069 is a reply to message #247067] Sat, 23 June 2007 10:07 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> break on deptno
SQL> select deptno, ename from emp order by 1,2;
    DEPTNO ENAME
---------- ----------
        10 CLARK
           KING
           MILLER
        20 FORD
           JONES
           SMITH
        30 ALLEN
           BLAKE
           JAMES
           MARTIN
           TURNER
           WARD

12 rows selected.

Regards
Michel
Previous Topic: Error while starting SQLPLUS!!!!!!
Next Topic: flashback .. to before drop
Goto Forum:
  


Current Time: Fri Dec 09 09:53:25 CST 2016

Total time taken to generate the page: 0.24340 seconds