1.新建一个java source:
2.创建调用的函数:
3.调用:
create or replace and compile java source named Hello as
public class Hello {
public static String sayHello(String name){
return "hello,"+name;
}
}
2.创建调用的函数:
create or replace function execHello(cmd varchar2) return varchar2
as language java
name 'Hello.sayHello(java.lang.String) return varchar2';
3.调用:
select execHello('kusix') from MDSYS.CS_SRS where rownum<2