Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Do you use PL/SQL

Re: Do you use PL/SQL

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Fri, 25 May 2007 22:14:46 +0100
Message-ID: <465751C6.7090504@dial.pipex.com>


DA Morgan wrote:
> Let me give you a short self-test to consider before you teach it.
> 1. When is it appropriate to commit inside of a loop?
> 2. When is it appropriate in 9i or 10g to use a cursor loop?
> 3. When should production code be deployed with stand-alone functions
> and procedures?
>
> If your answer to all three isn't ... "essentially never" ... reconsider.

interesting questions

I wouldn't answer any of them with your proposed answer by the way - though I see where you are coming from. I'd have said "when it doesn't matter". It's a bit like the BAARF stuff - mostly it really is irrelevant, truly irrelevant - knowing when it isn't counts, but so too does knowing when it is.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info/services
Received on Fri May 25 2007 - 16:14:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US