By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| ARCH_LOC | N | C |
|---|---|---|
| /home/oracle/arch | 1 | /home/oracle/arch |
| /home/oracle/arch | 2 | /home/oracle/ |
| /home/oracle/arch | 3 | /home/ |
| /home/oracle/arch | 4 | / |
| /a/b/c/d/e | 1 | /a/b/c/d/e |
| /a/b/c/d/e | 2 | /a/b/c/d/ |
| /a/b/c/d/e | 3 | /a/b/c/ |
| /a/b/c/d/e | 4 | /a/b/ |
| /a/b/c/d/e | 5 | /a/ |
| /a/b/c/d/e | 6 | / |
| /x1/y2/z3 | 1 | /x1/y2/z3 |
| /x1/y2/z3 | 2 | /x1/y2/ |
| /x1/y2/z3 | 3 | /x1/ |
| /x1/y2/z3 | 4 | / |