This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes table struture for storing hierarical data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "table struture for storing hierarical data" Watch "table struture for storing hierarical data" New topic
Author

table struture for storing hierarical data

priyanaka jaiswal
Ranch Hand

Joined: Jun 03, 2011
Posts: 79
Hi All,


In interview they ask me to write table struture for storing hierarical data IN ORACLE

CEO>> CTO>>PM>>TL>>SENIOR SOFTWARE ENGINEER>>ENGINEER any guidance will be great, i dont have any idea how to do it?


Thanks in advance
Carles Gasques
Ranch Hand

Joined: Apr 19, 2013
Posts: 199
    
    1
Hi,

Usually the structure will be [id, title, father_id] and utilize Oracle connect by prior query to retrieve the hierarchical data.


Best regards,
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: table struture for storing hierarical data
 
It's not a secret anymore!