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!

Inline Function vs Function

Discussion in 'SQL PL/SQL' started by learnerSaumya, Apr 25, 2010.

  1. learnerSaumya

    learnerSaumya Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Hi All,

    When should we use 'Inline Function & not Function' or 'Function & not Inline Function'?

    Thanks,
    Saumya
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Define what you mean by "inline function".
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
  4. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Or the Function declared and called inside proedure/function or package ?
     
  5. learnerSaumya

    learnerSaumya Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Hi Raj & Zargon, by Inline Function I am referring Inline Queries in a Select statement which could otherwise be declared as a Function.

    Thanks,
    Saumya
     
  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Give us an example of what you mean, please.