Home » SQL & PL/SQL » SQL & PL/SQL » 1 Package with many functions or many packages (Oracle)
1 Package with many functions or many packages [message #360475] Fri, 21 November 2008 02:34 Go to next message
rushimails
Messages: 24
Registered: November 2008
Location: Mumbai
Junior Member
Hi

I had one query, lets say I have many functions say to fetch date related details, numeric conversions, some string functions etc.
1. one way is to have one package with all aobve functions.
2. other way is make 3 packages with all date related functions in one package, all numerics in other and say all string etc in the other.

Which is better and faster.

Thnks
Rushi
Re: 1 Package with many functions or many packages [message #360483 is a reply to message #360475] Fri, 21 November 2008 02:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No one is better do it how you feel it, what you think should better for your organisation (for instance how often you will update them).

Regards
Michel
Re: 1 Package with many functions or many packages [message #360499 is a reply to message #360483] Fri, 21 November 2008 03:14 Go to previous messageGo to next message
rushimails
Messages: 24
Registered: November 2008
Location: Mumbai
Junior Member
Hi Michel

Lets say I use date functions very oftenly and numerics and string very rarely. what in case of such scenarios.

Rgd
Rushi
Re: 1 Package with many functions or many packages [message #360501 is a reply to message #360499] Fri, 21 November 2008 03:39 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Usage does not matter in the actual Oracle versions.

Regards
Michel
Previous Topic: constraints vs triggers
Next Topic: Reg : update only one row
Goto Forum:
  


Current Time: Sat Dec 03 09:47:55 CST 2016

Total time taken to generate the page: 0.07810 seconds