By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
9 rows affected
| Dept_ID | PR_Dept_ID | DeptName |
|---|---|---|
| 0000 | null | HR00 |
| 0001 | 0000 | HR01 |
| 0002 | 0000 | HR02 |
| 0003 | 0002 | HR03 |
| 0004 | 0002 | HR04 |
| 0005 | 0004 | HR05 |
| 0006 | null | INV00 |
| 0007 | 0006 | INV01 |
| 0008 | 0007 | INV02 |