Question { Oracle, 10147 }

What are the advantages of the packages

Answer

* The main advantage of package is one time compilation
process.while the first time of compilation the source code
is converted into P-code and stored in the database so that
for n no of time calling the pckg it does not take any
memory locations...
*Then whatevere the database objects declared in the
package specification will be globally accessible.

Question { 9990 }

What is the basic structure of PL/SQL ?

Answer

Declare
begin
exception
end;

Question { 10369 }

Name the tables where characteristics of Package, procedure
and functions are stored ?

Answer

user_objects
user_source
user_dependencise
ideptree

Question { Google, 7252 }

I need data on eBay customers in Chicago who can did bid on
certain item? I dont have access to eBay database directly.
How I get the information?

Answer

The owner of the table should grand the access privilege to
u...or u can access the remote database by using database
link....

if their is any issue mail me @
rajesh_natesh@yahoo.com or rajesh.natesh@cognizant.com

Question { eBay, 7175 }

What is cursor and where do you use them?

Answer

Cursor is an named private area called active set which is
used to process the multiple rows returned by the query....
cursors are mainly used in procedure/package/function when
the select qurey in procedure/package/function returns
more than one value....

if their is any issue mail me @
rajesh_natesh@yahoo.com,rajesh.natesh@cognizant.com