Could anyone help with rewriting this query? Result of this query will be inserted into a table. Thanks!
SELECT tableA.PK,
table1.amt,
table2.amt,
table3.amt,
....
table16.value
FROM tableA,
(SELECT fk, NVL(value, 0) AS amt
FROM tableB
WHERE name = 'name1') table1,
...
(SELECT fk, NVL(value, 0) AS amt
FROM tableB
WHERE name = 'name16') table16
WHERE table1.fk (+) = tableA.pk
AND table2.fk (+) = tableA.pk
...
AND table16.fk (+) = tableA.pk;