SQL Performance (MOSC)

MOSC Banner

How to write Recursive With Query for my requirment

edited Feb 7, 2014 3:21PM in SQL Performance (MOSC) 10 commentsAnswered
I have a query which gives me the part# with additional sales information.

Case 1  This part# is under another component. first level

Case 2: This part# is under another component's  component . 2nd level. Sometimes it may exist in nth level.

How to write the REcursive with clause.?

  Select     part#, I can get other component here. level1  but if  part# exists in nth component how to get it  

  from 

  table

Appreciate if you can guide with any suggestion or pseduo logic

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