Re: PL/SQL coding style

Hi Chandrini,

Of course, "select into" is more efficient since Oracle8 ( up to 30% ), but I would advise to use explicit cursors for readability. Generally, "select into" can be used when it's the only one operator in a procedure or when you don't expect get a "no_data_found" or "too_many_rows". As for using "goto" - anyone should avoid it according to the concepts of structural programming.

HTH,
Michael Netrusov,
www.atelo.com
(202) 262 8469
(877) 528 0090

PS: "C" code styling has nothing to do with "goto".

• Original Message ----- From: "Chandini Paterson" <chandini.paterson_at_morse.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 18, 2001 11:01 Subject: PL/SQL coding style

> Hi gurus,
> I've just changed jobs quite recently and am already having problems
with
> my Senior Developer (yippee)
> It concerns the PL/SQL coding style. The guy insists that I use 'SELECT
> ..INTO ' in my code rather than explicit cursors, even though I tried
> telling him it is more efficient with the latter. He apparently finds it
> more 'readable' with the 'SELECT.. INTO ' and says that the double fetch
> (for each row) is 'no big deal'.
> Also, he insists of using a lot of GOTOs in his code and expects me to
do
> the same. I am adamant that we use EXCEPTION handlers to achieve the same
> thing (BAsically he checks for error conditions in his code and then does
a
> 'goto error_handler' to handle the error!!!). I prefer using EXCEPTIONS to
> handle all my error conditions.
> I was just wondering if my concepts are all wrong at this time. I am
just
> curious to know if any of you find his way of coding style preferable to
> mine. (OH, by the way, he was initially a 'C' progrmmer). Any inputs will
> be greatly appreciated.
>
> Thanks
> Chandini
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Chandini Paterson
> INET: chandini.paterson_at_morse.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Jan 18 2001 - 10:59:51 CST