Home » SQL & PL/SQL » SQL & PL/SQL » packages (oracle)
packages [message #387205] Wed, 18 February 2009 04:32 Go to next message
tamil
Messages: 22
Registered: April 2007
Location: chennai
Junior Member
1)what is procedure,function,packages?

2)why are we using packages? why cannot we use procedure and function instead of package and what is the advantage of using packages?
Re: packages [message #387207 is a reply to message #387205] Wed, 18 February 2009 04:37 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
These basic questions are answered in the PL/SQL User's Guide and Reference.
1. link
2. link

Here's an extra tip: bookmark http://tahiti.oracle.com. There you'll find the Oracle online documentation.

MHE
Re: packages [message #387208 is a reply to message #387205] Wed, 18 February 2009 04:38 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Are you reluctant to read the oracle reference manual or you do not know how to use google.

http://www.google.co.uk/search?hl=en&q=advantage+of+packages+in+oracle&meta=

Scan through the link and read it.

Regards

Raj
Previous Topic: Variable with many values
Next Topic: Cursor
Goto Forum:
  


Current Time: Sat Dec 03 03:43:23 CST 2016

Total time taken to generate the page: 0.08197 seconds