SQL/PL SQL help

From: Rushika Pandya <rushika.pandya_at_natinst.com>
Date: 1997/10/24
Message-ID: <01bcdd96$4f1461e0$1c16a482@castillo.natinst.com>#1/1

I have a table that is a parent/child table. This table has five levels. One of the attributes can be defined at any one of these five levels. I want to be able to select the level_id where this attribute is not null.

The searching preference is level 5..level1.

I know how to get the attribute value:
nvl(table5.attribute, nvl(table4.attribute, nvl(table3.attribute, nvl(table2.attribute, nvl(table1.attribute, '0') but I do not know how to get the corresponding level value...

How would I go about doing this... Received on Fri Oct 24 1997 - 00:00:00 CDT