这个问题太泛了。。能说清，都可以写好几本书。可以参考tom的原则：You should do it in a single SQL statement if at all possible. If you cannot do it in a single SQL Statement, then do it in PL/SQL. If you cannot do it in PL/SQL, try a Java Stored Procedure. If you cannot do it in Java, do it in a C external procedure. If you cannot do it in a C external routine, you might want to seriously think about why it is you need to do it... 看看tom的expert就会有点答案了。
看看tom的expert就会有点答案了。
http://www.bitscn.com/oracle/optimize/200604/19329.htmlhttp://www.winu.cn/space-14160-do-blog-id-349.html