79374465

Date: 2025-01-21 12:52:06
Score: 1
Natty:
Report link

Since there is no function/clause/pseudocolumn which could realise this specific need, I would use a combination of sys_connect_by_path with substr to get the sixth id on the path

Reasons:
  • Low length (1):
  • No code block (0.5):
  • Single line (0.5):
  • High reputation (-1):
Posted by: Marcin Wroblewski