By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create function "MyFUNCTION" return number is
begin
return 42;
end;
/
SELECT dump (CAST(DBMS_METADATA.GET_DDL('FUNCTION', 'MyFUNCTION', user) AS VARCHAR2(4000)), 16) FROM DUAL
| DUMP(CAST(DBMS_METADATA.GET_DDL('FUNCTION','MYFUNCTION',USER)ASVARCHAR2(4000)),16) |
|---|
| Typ=1 Len=126: a,20,20,43,52,45,41,54,45,20,4f,52,20,52,45,50,4c,41,43,45,20,45,44,49,54,49,4f,4e,41,42,4c,45,20,46,55,4e,43,54,49,4f,4e,20,22,46,49,44,44,4c,45,5f,51,53,49,41,4b,57,59,57,55,45,59,53,41,4e,4a,56,4d,4f,50,49,22,2e,22,4d,79,46,55,4e,43,54,49,4f,4e,22,20,72,65,74,75,72,6e,20,6e,75,6d,62,65,72,20,69,73,a,62,65,67,69,6e,a,20,20,72,65,74,75,72,6e,20,34,32,3b,a,65,6e,64,3b,a |
SELECT dump (CAST(DBMS_METADATA.GET_DDL('FUNCTION', 'MyFUNCTION', user) AS VARCHAR2(4000)), 1016) FROM DUAL
| DUMP(CAST(DBMS_METADATA.GET_DDL('FUNCTION','MYFUNCTION',USER)ASVARCHAR2(4000)),1016) |
|---|
| Typ=1 Len=126 CharacterSet=AL32UTF8: a,20,20,43,52,45,41,54,45,20,4f,52,20,52,45,50,4c,41,43,45,20,45,44,49,54,49,4f,4e,41,42,4c,45,20,46,55,4e,43,54,49,4f,4e,20,22,46,49,44,44,4c,45,5f,51,53,49,41,4b,57,59,57,55,45,59,53,41,4e,4a,56,4d,4f,50,49,22,2e,22,4d,79,46,55,4e,43,54,49,4f,4e,22,20,72,65,74,75,72,6e,20,6e,75,6d,62,65,72,20,69,73,a,62,65,67,69,6e,a,20,20,72,65,74,75,72,6e,20,34,32,3b,a,65,6e,64,3b,a |