Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT vg.vo_group_id,
- vg.name,
- vg.vehicle_owner_id,
- vg.graphical_symbol,
- vg.lm_comment,
- vg.company_nr,
- vg.parent_vo_group_id
- FROM vo_group vg
- CONNECT BY prior vg.vo_group_id = vg.parent_vo_group_id
- START WITH vg.parent_vo_group_id IS NULL
- ORDER siblings BY vg.parent_vo_group_id, vg.vo_group_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement