Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ID PAR_ID TABLE_NAME
- -- ------ ----------
- 1 table2
- 2 1
- 3 2 table3
- ID DESCR
- -- -----
- 1 Вопрос1
- 2 Вопрос2
- 3 Вопрос3
- SELECT
- LPAD(' ', (level - 1) * 2) || CASE
- WHEN t1.par_id IS NULL THEN
- 'Категория К' || t1.id
- ELSE
- 'Подкатегория К' || t1.par_id || '.' || t1.id
- END AS name,
- t1.table_name
- FROM table1 t1
- CONNECT BY PRIOR t1.id=t1.par_id
- START WITH t1.par_id IS NULL;
- Категория Кх
- ...
- Топик i
- ...
- Топик m
- ...
- Подкатегория Кх.n
- ...
- Топик i
- ...
- Топик m
Add Comment
Please, Sign In to add comment