a pretty simple philosophy

• 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 (but as little PL/SQL
as possible!).
• If you cannot do it in PL/SQL (due to some missing feature like listing the files in a
directory), try a Java stored procedure. This is an extremely rare need today with
Oracle9i and above.
• If you cannot do it in Java, do it in a C external procedure. This is most frequently the
approach when raw speed or the use of a third-party API written in C is needed.
• If you cannot do it in a C external routine, you might want to think seriously about why
exactly you need to do it.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10742223/viewspace-345681/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10742223/viewspace-345681/