Hi All,
I need a suggestion. Suppose we insert records using insert select and the query is ' insert into select * from ( inner query with so many left joins with 5 tables and than in where clause ( inner query with case,sum aggregation kinda logic)) ' ....In these case , do we need to use insert select method or bulk collect. Which is appropriate ? Do we really need to have everything in SQL itself just because we can do it. Why not in PL/SQL . I knew insert select is better than bulk collect but will it fit in the scenario I mentioned above.
Its Oracle 11G and each tables have 10 million records