Is it possible to view the source code used for defining functions in Oracle?
eg., concat function...??
Thanks.
Printable View
Is it possible to view the source code used for defining functions in Oracle?
eg., concat function...??
Thanks.
I guess no
i think i am wrong....u can get it..Quote:
Originally posted by abhaysk
I guess no
If this is not wat u r lokking for .... then i mis understood ur question...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);
Abhay
From where did you get this ? Thanks.Quote:
Originally posted by abhaysk
i think i am wrong....u can get it..
If this is not wat u r lokking for .... then i mis understood ur question...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);
Abhay
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.Quote:
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.
I guess all DBMS supplied packages are wrapped..
Abhay.
No, not all. But most are.Quote:
Originally posted by abhaysk
Package body is not wrapped for STANDARD.
I guess all DBMS supplied packages are wrapped..
Abhay.
Oh yes, standard isn't, is it?
I always enjoy the comments in the code
Quote:
Perhaps this can be done more intelligently in the future. JEM 3/14/90.
Quote:
let implicit conversion do for them