Home » Other » General » drawing organizational charts
drawing organizational charts [message #262520] Mon, 27 August 2007 06:19 Go to next message
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

Re: drawing organizational charts [message #262535 is a reply to message #262520] Mon, 27 August 2007 07:31 Go to previous messageGo to next message
Littlefoot
Messages: 20897
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.
Re: drawing organizational charts [message #262636 is a reply to message #262535] Mon, 27 August 2007 23:52 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
  dont  look for  soultions,  try to learn  the hierarchy (tree)
concept

regards

PEACE
Re: drawing organizational charts [message #262678 is a reply to message #262520] Tue, 28 August 2007 01:14 Go to previous messageGo to next message
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
Re: drawing organizational charts [message #262681 is a reply to message #262678] Tue, 28 August 2007 01:16 Go to previous message
Littlefoot
Messages: 20897
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.
Previous Topic: my question form oracle administrators
Next Topic: Cannot collect and verify hardware infromation for all the nodes...
Goto Forum:
  


Current Time: Wed Dec 07 02:39:46 CST 2016

Total time taken to generate the page: 0.10393 seconds