Solved

What is an Oracle package?

Posted on 2013-06-13
3
512 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 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 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 76

Expert Comment

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

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

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
unable to get sorting resultset 15 72
Oracle 10g - insert string with special characters 8 55
Repeat query 13 46
Oracle Verification of DataPump Export and Import 17 55
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

776 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