• 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,
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!