1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

stored procedures and packages using various database objects

Discussion in 'SQL PL/SQL' started by laxman, Dec 25, 2009.

  1. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    Dear all,
    need an urgent help,can anybody provide me any URL or send me material that should contains only source code of stored procedures and packages using various database object or built in packages or collections etc.

    will be highly grateful for your coordination.

    Thanks n regards
    Laxman
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    I don't understand your demands -- what type of stored procedures to you want people to simply give you? Why do you 'need' such things 'urgently'?
     
  3. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    Dear sir,
    Extremly sorry for quering this kind of issues also,actually i need to get some basic ideas about how logically a stored procedure or package is being implemented using various database object.

    Thanks n regards
    Laxman
     
  4. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    do you mean the database architecture?
     
  5. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    I think the collective application and database instances that comprise the complete system define the database archietecture.
    am i correct sir?

    Regards
    Laxman
     
  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Not necessarily. Such as you describe could be considered the system configuration with the database architecture a mere piece of that puzzle.

    I think you need to provide some example descriptions of what you want: what sort of database objects should these procedures/packages include, what types of coding constructs do you want to see, what types of packages/procedures does this company use? There is a wide array of examples to be had, but to simply flood you with code not knowing what areas concern you would be irresponsible.
     
  7. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    ya sure sir,i will definitly let you know.

    Thanks n regards
    Laxman