jump to navigation

Packages in Oracle vs IBM DB2 February 19, 2010

Posted by sendtoshailesh in DB2.

I was trying to find out the features of oracle database in Db2. If we talk about oracle package in Db2, its not there but package term is there and its utility is completely different in Db2. Its is not the same thing what package is there in Oracle.

I gooooooogled it. Found a good article (http://www.ibm.com/developerworks/data/library/techarticle/dm-0606chun/index.html)  about it. I am just highlighting it………

Packages in DB2 are control-structure database objects that contain executable forms of SQL statements or placement holders for executable forms. In DB2 for Linux®, UNIX®, and Windows®, packages may also be referred to as access plans. Packages are stored in the database system catalog tables.

If an application intends to access a database using static SQL, the application developer must embed the appropriate SQL statements in the program source code. When the program source code is converted to an executable object (static SQL) or executed (dynamic SQL), the strategy for executing each embedded SQL statement is stored in a package as a single section. Each section is a bound form of the embedded SQL statement, and this form contains information such as which index to use and how to use the index (basically an access plan).

Package in Oracle means very vast implementation of OOP in database. if one want to implement Data Hiding, Overloading, Inheritance and blah blah…. from the concept of Object Oriented Programming (OOP) / Object Oriented Technology (OOT), Package is the way to do it.

This can be explained in many way and here I thought let me explain mind of a layman.



1. parallax web design - June 29, 2014

It’s fantastic that you are getting thoughts from this article
as well as from ourr argument made at this

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: