[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

What is an Oracle package?

Posted on 2013-06-13
3
Medium Priority
?
524 Views
Last Modified: 2013-06-13
What is an oracle package and why would I use it?
0
Comment
Question by:patriotpacer
  • 2
3 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 39244442
In a nutshell:  It's a collection of related objects.

You use it to 'bundle' related objects into a single container.

It also makes grants easier.  Say you have 10 functions and procedures that specific users need to access:  Put them all in a package, grant them execute on the package and they can now all use all 10 objects.

Since you are new to Oracle, I suggest you spend some time in the Concepts guide.

PL/SQL Packages

http://docs.oracle.com/cd/E11882_01/server.112/e25789/srvrside.htm#i18829
0
 

Author Closing Comment

by:patriotpacer
ID: 39244448
>>You use it to 'bundle' related objects into a single container.

That's what I suspected.

>>Since you are new to Oracle, I suggest you spend some time in the Concepts guide.

will do

thx for all your help today.  I really appreciate it.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39244464
No problem.

Keep asking the questions, we'll keep answering them!!!
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses
Course of the Month19 days, 5 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question