1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| drop table service;
create table service AS
(
SELECT 1 id, NULL id_parent, 'direction' nom, 1 niveau FROM dual
UNION SELECT 2, 1, 's-dir1' , 2 FROM dual
UNION SELECT 3, 1, 's-dir2' , 2 FROM dual
UNION SELECT 4, 2, 'ss-dir1' , 3 FROM dual
UNION SELECT 5, 2, 'ss-dir2' , 3 FROM dual
UNION SELECT 6, 4, 'div1' , 4 FROM dual
UNION SELECT 7, 4, 'div2' , 4 FROM dual
UNION SELECT 8, 5, 'div3' , 4 FROM dual
UNION SELECT 9, 5, 'div4' , 4 FROM dual
UNION SELECT 10, 4, 'div5' , 4 FROM dual
UNION SELECT 11, 5, 'div6' , 4 FROM dual
) ; |
Partager