How to isolate directories in path in loop?

[nir_s]

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

[gandolf989]

Did you look at the sys.dbms_backup_restore package?

[nir_s]

Hi gandolf989,

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

Nir

[guru_heaven]

use instr and substr

[nir_s]

Hi guru_heaven,

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

Best regards,
Nir