Suppose I'm adding row to a table, and one of the columns is a pathname.
I would like to generate in a separate table parent/child relationships based on the path.
For example, adding "/foo/bar/baz" and "/foo/bar/bot" would generate the following relationships
parent child ------ ----- /foo /foo/bar /foo/bar /foo/bar/baz /foo/bar /foo/bar/bot
Is this a reasonable thing to do in a trigger? Does anybody have a pl/sql snippet to do this?
Many TIA, Mark
-- Mark Harrison Pixar Animation Studios
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
