Please help me to create recursive SQL using Recursive With Clause
@Recursive With Clause>
I have a view in which all list of final assemblies, organization codes and components data is existing.
I have to write sql to find list of all final assemblies wherein a component is used.
select * from vel_cust_v where compononet ='x' it gives me final assemblies.
further these final assemblies to searched as component to get their final assemblies and like this upto n level.
select * from view where component ='above final assemblies'
Please suggest if we can use Recursive With Clause in Oracle 11g.
Appreciate quick reply
thanks