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.
- 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.
Sunday, September 16, 2007
Subscribe to:
Comments (Atom)