We can load various resources like jar,zip,text,imges using loadjava utility
loadjava -user userid/password HelloWorld.class
SELECT object_name, object_type, status
FROM user_objects
WHERE object_name LIKE '%Hello%';
create or replace function HELLO return VARCHAR2 as language java name 'Hello.world () return java.lang.String';
variable myString varchar2(20);
call HELLO2 into :myString;
select HELLO from dual;
No comments:
Post a Comment