RE: Package/Procedure

From: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Tue, 16 Apr 2002 17:33:21 -0800
Message-ID: <F001.00445F30.20020416173321@fatcity.com>

Hi Laura,

We use P_XXX_ for procedures, F_XXX_ for functions and K_XXX_ for packages where XXX is our application initial as we've many applications in one instance. Eg. P_STD_Update is a procedure pertaining to Student (STD) System.

HTH
Catherine

		-----Original Message-----
		From:	BALA,PRAKASH (Non-HP-USA,ex1)
[mailto:prakash_bala_at_non.hp.com]
		Sent:	Wednesday, April 17, 2002 4:08 AM
		To:	Multiple recipients of list ORACLE-L
		Subject:	RE: Package/Procedure

		I use sp_ for procedures; sf_ for functions and pkg_ for

packages.

		HTH
		Prakash

		-----Original Message-----
		Sent: Tuesday, April 16, 2002 3:49 PM
		To: Multiple recipients of list ORACLE-L


		It's as good idea.  It's whatever you choose, whatever makes
sense to you.
		As long as you ensure everyone in your shop adheres to it...

		Lisa Koivu
		Oracle Database Administrator
		Fairfield Resorts, Inc.
		954-935-4117




		> -----Original Message-----

		> From:	Burton, Laura L. [SMTP:BurtonL_at_prismplus.com]

		> Sent:	Tuesday, April 16, 2002 3:25 PM

		> To:	Multiple recipients of list ORACLE-L

		> Subject:	Package/Procedure

		> 

		> Is there a naming convention for procedures and/or

packages? 


		> 

		> Thank you,

		> 

		> Laura

		> 

		-- 
		Please see the official ORACLE-L FAQ: http://www.orafaq.com
		-- 
		Author: Koivu, Lisa
		  INET: lisa.koivu_at_efairfield.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).
		-- 
		Please see the official ORACLE-L FAQ: http://www.orafaq.com
		-- 
		Author: BALA,PRAKASH (Non-HP-USA,ex1)
		  INET: prakash_bala_at_non.hp.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

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 Tue Apr 16 2002 - 20:33:21 CDT