OraFAQ Forum: Client Tools » Matrix out put

Home » Other » Client Tools » Matrix out put

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Matrix out put [message #247067]

Sat, 23 June 2007 08:52

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
..

Report message to a moderator

Re: Matrix out put [message #247069 is a reply to message #247067]

Sat, 23 June 2007 10:07

Michel Cadot
Messages: 68641
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

Report message to a moderator

Previous Topic:	Error while starting SQLPLUS!!!!!!
Next Topic:	flashback .. to before drop

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 09:22:32 CDT 2024