How to isolate directories in path in loop?

Hi folks,

I need to write a procedure which get from outside a path as string.
I need to isolate every folder in the path using a loop and check for each directory (tool name) its tool id and its tool_father in a table (T_TOOLS_TREE).

following an example for path:
Objects/SUI Framework/page

How to isolate directories in a path?

Thanks for advance,
Nir

Did you look at the sys.dbms_backup_restore package?

Hi gandolf989,

Thanks for your reply.
I looked at this package but I don't think it fit to my problem.
Thanks anyway!

Nir

use instr and substr

Hi guru_heaven,

Thanks!
I've just finished to write the procedure with SUBSTR/INSTR and it works perfect!

Best regards,
Nir