Skip to content

Tag: connect-by

Oracle SQL Recursive Query When FieldType is Subpage

I have a table PanelDefn which has list following fields I would like to write a query which recursively gives the data for SubPanel when I query for Panel. It means whenever we encounter FieldType=11 , we need to have recursive query for that. I tried using connect-by. Answer I guess you need below query &#8…