Two Laptop Bag*
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


Win a copy of Spring in Action this week in the Spring forum!
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 agree. Here's the link: http://aspose.com/file-tools
 
subject: table struture for storing hierarical data