DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: View concat function source ??

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    View concat function source ??

    Is it possible to view the source code used for defining functions in Oracle?

    eg., concat function...??

    Thanks.

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    I guess no
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by abhaysk
    I guess no
    i think i am wrong....u can get it..

    Code:
      function CONCAT(LEFT CLOB CHARACTER SET ANY_CS,
                      RIGHT CLOB CHARACTER SET ANY_CS)
            return CLOB CHARACTER SET LEFT%CHARSET;
        pragma FIPSFLAG(CONCAT, 1454);
     
     function CONCAT(LEFT VARCHAR2 CHARACTER SET ANY_CS,
                      RIGHT VARCHAR2 CHARACTER SET ANY_CS)
            return VARCHAR2 CHARACTER SET LEFT%CHARSET;
        pragma BUILTIN(CONCAT,25, 1, 7); -- PEMS_CHAR, CHAR_CONCAT
        pragma FIPSFLAG(CONCAT, 1454);
    If this is not wat u r lokking for .... then i mis understood ur question...

    Abhay
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by abhaysk
    i think i am wrong....u can get it..

    Code:
      function CONCAT(LEFT CLOB CHARACTER SET ANY_CS,
                      RIGHT CLOB CHARACTER SET ANY_CS)
            return CLOB CHARACTER SET LEFT%CHARSET;
        pragma FIPSFLAG(CONCAT, 1454);
     
     function CONCAT(LEFT VARCHAR2 CHARACTER SET ANY_CS,
                      RIGHT VARCHAR2 CHARACTER SET ANY_CS)
            return VARCHAR2 CHARACTER SET LEFT%CHARSET;
        pragma BUILTIN(CONCAT,25, 1, 7); -- PEMS_CHAR, CHAR_CONCAT
        pragma FIPSFLAG(CONCAT, 1454);
    If this is not wat u r lokking for .... then i mis understood ur question...

    Abhay
    From where did you get this ? Thanks.

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    This is just the (overloaded) interface to the function, from the STANDARD package presumably, The package body is wrapped, so you can't see that, and it would mostly be low level os calls/external proc calls, i would guess.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by slimdave
    This is just the (overloaded) interface to the function, from the STANDARD package presumably, The package body is wrapped, so you can't see that, and it would mostly be low level os calls/external proc calls, i would guess.
    Package body is not wrapped for STANDARD.

    I guess all DBMS supplied packages are wrapped..

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by abhaysk
    Package body is not wrapped for STANDARD.

    I guess all DBMS supplied packages are wrapped..

    Abhay.
    No, not all. But most are.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Oh yes, standard isn't, is it?

    I always enjoy the comments in the code

    Perhaps this can be done more intelligently in the future. JEM 3/14/90.
    let implicit conversion do for them
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width