OraFAQ Forum: General » drawing organizational charts

Home » Other » General » drawing organizational charts

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

drawing organizational charts [message #262520]

Mon, 27 August 2007 06:19

nadia74
Messages: 85
Registered: August 2007

Member

Hello - I have oracle database 10g.
I want to drawe an organizational chart include the hierarchy of the employees in table emp.
Is there a way or a tool to do that?
Thanks
Nadia

Report message to a moderator

Re: drawing organizational charts [message #262535 is a reply to message #262520]

Mon, 27 August 2007 07:31

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

SQL*Plus?

SQL> SELECT LPAD('-', LEVEL, '-') || ' '|| ename lvl, job
  2  FROM EMP
  3  CONNECT BY PRIOR empno = mgr
  4  START WITH mgr IS NULL;

LVL                            JOB
------------------------------ ---------
- KING                         PRESIDENT
-- JONES                       MANAGER
--- SCOTT                      ANALYST
---- ADAMS                     CLERK
--- FORD                       ANALYST
---- SMITH                     CLERK
-- BLAKE                       MANAGER
--- ALLEN                      SALESMAN
--- WARD                       SALESMAN
--- MARTIN                     SALESMAN
--- TURNER                     SALESMAN
--- JAMES                      CLERK
-- CLARK                       MANAGER
--- MILLER                     CLERK

14 rows selected.

Report message to a moderator

Re: drawing organizational charts [message #262636 is a reply to message #262535]

Mon, 27 August 2007 23:52

sispk6
Messages: 164
Registered: November 2006
Location: pakistan

Senior Member

  dont  look for  soultions,  try to learn  the hierarchy (tree)
concept

regards

PEACE

Report message to a moderator

Re: drawing organizational charts [message #262678 is a reply to message #262520]

Tue, 28 August 2007 01:14

nadia74
Messages: 85
Registered: August 2007

Member

Thanks for your reply, but i don't want to draw the hierarchy as a tree in SQL*Plus. I want to draw it as a diagram.
example:

       KING
          /      |     \
      JONES     BLAKE  CLARK
      /   \      |      |
   SCOTT  FORD  ALLEN  MILLER
     |      |    |
   ADAMS  SMITH WARD
                 |
                MARTIN

I've found that visio 2003 can do this kind of diagrams, but the problem is that when adding or deleting it doesn't reflect to the database.
any other program or an active x controler can do that?
regards

Report message to a moderator

Re: drawing organizational charts [message #262681 is a reply to message #262678]

Tue, 28 August 2007 01:16

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm sorry, I wouldn't know. I thought you were looking for a query.

Report message to a moderator

Previous Topic:	my question form oracle administrators
Next Topic:	Cannot collect and verify hardware infromation for all the nodes...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 15:49:56 CDT 2024