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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: PL/SQL coding style - thanks

RE: PL/SQL coding style - thanks

From: Chandini Paterson <chandini.paterson_at_morse.com>
Date: Fri, 19 Jan 2001 10:29:10 -0000
Message-Id: <10746.127111@fatcity.com>


Thanks for the input everybody. I liked the idea of using the shot gun a whole lot, Hmmmm real temptation there :-)) Anyway, thanks a lot.
Chandini

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rachel Carmichael
Sent: 19 January 2001 02:25
To: Multiple recipients of list ORACLE-L Subject: RE: PL/SQL coding style

Kevin Looney? uh.... no, Loney,that's it,. Loney

and you have style.... the Appendix deals with coding in PL/SQL but is not, in any way, shape or form, a coding manual

Steven Feuerstein has written several books on PL/SQL that ARE the best around.

>From: "Steve Orr" <sorr_at_arzoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: PL/SQL coding style
>Date: Thu, 18 Jan 2001 14:39:03 -0800
>
>Speaking of style, Rachel humbly did not mention her book because she has
>style. But since I have none it's "Oracle SQL & PL/SQL Annotated Archives"
>from Oracle Press. Oh yeah, it's co-author by some guy named Kevin
>something. :-)
>
>ever so gauche,
>Steve Orr
>
>
>
>-----Original Message-----
>Carmichael
>Sent: Thursday, January 18, 2001 11:29 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Doesn't sound like C style to me... that sort of coding style (the gotos)
>goes back to when I first started programming in Cobol and Fortran (yes, my
>age is showing)
>
>As for the select into.. double fetch is, or can be, a big deal.
>
>If your code works, he should not be imposing his style on you.
>
>My $.02
>
> >From: "Chandini Paterson" <chandini.paterson_at_morse.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: PL/SQL coding style
> >Date: Thu, 18 Jan 2001 08:01:58 -0800
> >
> >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: Steve Orr
> INET: sorr_at_arzoo.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).



Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: carmichr_at_hotmail.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
Received on Fri Jan 19 2001 - 04:29:10 CST

Original text of this message

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