Hi,
Quick question on the Hierarchy Query.
In the query of Oracle BOM need to multiply the qty from the top to the lowest nodes.
Query is working fine with all low level rows. But need to multiply the qty from low to the top.
Had the below connect by which is giving correct values : .0228*1*1 or .0228*1*1*2
depending on number of levels.
However need to get the multiplication of these qty. How to parse this sting ex: .0228*1*1 = .0228.
Is there a easy way instead of using the sting commands (instr) to parse the values and multiply.
SYS_CONNECT_BY_PATH(q_bom.QTY, '*'),2) QTY_PATH
thanks