Results 1 to 4 of 4

Thread: Oracle Package

  1. #1
    Junior Member
    Join Date
    Dec 2011
    Answers
    16

    Post Oracle Package

    What is package ? Advantages of package ?


  2. #2
    Administrator
    Join Date
    May 2006
    Answers
    331

    Re: Oracle Package

    Pradeep,

    A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification or spec or package header and Package Body

    Please read the complete tutorials on packages . Oracle 9i Packages

    Thanks,


  3. #3
    Junior Member
    Join Date
    Jan 2013
    Answers
    9

    Re: Oracle Package

    package is collection of procedures and funtion and cursors..
    there are two types of packages 1) Package specification and 2) Package Body,
    (or)
    package is schema object that are groped related collecation of objects and pl/sql datatypes and subprograms and items,

    advantages of packages: modurality,easi application creation,better performance and information hiding...

    for more details go through following
    docs.oracle.com/cd/B10501_01/appdev.920/a96624/09_packs.htm
    docs.oracle.com/cd/E14072_01/appdev.112/e10472/packages.htm


  4. #4
    Junior Member
    Join Date
    Jan 2013
    Answers
    9

    Re: Oracle Package

    package is schema that groups related pl/sql data types and items and sub-programs.
    (or)
    package is collection of cursors and functions and procedures..

    Advantages of Package:-
    Better performance,modularity,infromation hiding,


  5.  Sponsored Ads
    Ad


     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact