-
View concat function source ??
Is it possible to view the source code used for defining functions in Oracle?
eg., concat function...??
Thanks.
-
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"
-
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"
-
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.
-
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.
-
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"
-
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|