Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

drawing an organizational chart

580342Aug 28 2007 — edited Aug 29 2007
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2007
Added on Aug 28 2007
3 comments
501 views