Replies posted by Dualta

3 Replies

durette
Superhero (Customer)
duretteSuperhero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

SQL for Visualizing Product Structure

need it to keep going up and multiplying each qty be each other to reached top level

7
D
Do Gooder (Partner)
3 years ago
durette
Superhero (Customer)
duretteSuperhero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

SQL for Visualizing Product Structure

not exactly what im lookiing for..for example SYS_CONNECT_BY_PATH(qty_per_assembly, '*')  will go down say 3 levelsand give me *1*11*.022222,But I want this to multiply as it goes down , so this should show be evaluated as 1x11x.022222 so would have Coolum converting this to say 0.22  

7
D
Do Gooder (Partner)
3 years ago
durette
Superhero (Customer)
duretteSuperhero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

SQL for Visualizing Product Structure

How would you multiply the qty_per_assembly as you go down each level?

7
D
Do Gooder (Partner)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings