Query Help...

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Mon, 23 Jan 2006 15:04:35 +0530
Message-ID: <75aa80160601230134j4da7da47ndc698d98a1a6c330@mail.gmail.com>

Hi All,

Have a table like ...

FOLDER_ID PARENT_ID
----------------- ---------------

001

002              001
003              002
004              003
005             004

and so on....

The parent_ID is the foreign key referencing FOLDER_ID column of the same table.

Want a SQL which deletes the bottom most folder_id i.e., 005 in the above case, and then 004 and then 003 ....

Do not want to use cascade delete....
**

--

Regards,

Deepak
Oracle DBA

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 23 2006 - 03:34:35 CST