Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

table struture for storing hierarical data

 
priyanaka jaiswal
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 199
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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


Best regards,
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic