SQL Language (MOSC)

MOSC Banner

Please help me to create recursive SQL using Recursive With Clause

edited Sep 25, 2014 4:28PM in SQL Language (MOSC) 7 commentsAnswered

@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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center