Oracle開發路線

A pretty simple mantra when it comes to developing database software:

1. You should do it in a single SQL statement if at all possible.
我們應該儘量使用單個SQL語句來實現應用需求;

2. If you cannot do it in a single SQL Statement, then do it in PL/SQL.
如果單個SQL無法實現，考慮使用PL/SQL來實現;

3. If you cannot do it in PL/SQL, try a Java Stored Procedure.
如果PL/SQL無法實現，接下來可以嘗試使用Java儲存過程來實現;

4. If you cannot do it in Java, do it in a C external procedure.
如果Java過程也不行，嘗試使用C的外部儲存過程來解決;

5. 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...
如果以上都不能實現，那麼你應該認真考慮你為什麼要實現這個需求...

[@more@]