drawing an organizational chart

To discuss Oracle Forms & Reports related technical issues.
Post Reply
nadia
Posts: 15
Joined: Mon May 14, 2007 1:26 am
Location: Syria

drawing an organizational chart

Post by nadia »

Hello - I have oracle database 10g.
I want to draw an organizational chart include the hierarchy of the employees in table emp,
but i don't want to draw the hierarchy as a tree in SQL. 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 shapes to the diagram it doesn't reflect to the database.
Is there a way or a tool or an active x controler can do that?
regards
Post Reply

Who is online

Users browsing this forum: No registered users and 9 guests