Friday, September 28, 2007

Ask Tom - Mantra

Ask Tom: -On Cursors, SQL, and Analytics:
- You should do it in a single SQL statement if at all possible.
- If you cannot do it in a single SQL statement, 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 procedure,
you might want to seriously think about why it is you need to do it.