select a.*, level leaf from stnd_class a start with a.node_no ='GB' connect by a.parent_node_id = prior a.id