Oracle - Generation format to Parent / child format hierarchies
I have a hierarchy in generation format and need to convert it to parent / child format. Does someone have some SQL code to do this? I'm in a time crunch and this is an unexpected obstacle. Any help is very much appreciated!