在Oracle中使用java对象

1.写一个java对象，保存在c:/Hello.java

2.loadjava -user scott/tiger@223 Hello.java ，将Hello.java加入到数据库中，如果加入的是源码，则可以从javasource中看到，如果加载的是class，从javasource看不到

3.查询加载的对象。

SQL> select * from user_java_classes where rownum=1;

NAME                                                                                  MAJOR      MINOR KIND      ACCESSIBILITY IS_INNER IS_ABSTRACT IS_FINAL IS_DEBUG SOURCE                                                                           SUPER                                                                            OUTER
-------------------------------------------------------------------------------- ---------- ---------- --------- ------------- -------- ----------- -------- -------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
Hello                                                                                    49          0 INTERFACE PUBLIC        NO       NO          NO       NO       Hello.java                                                                       java/lang/Object                                                                 -

4.loadjava可以加载class,jar,resource,properties

5.加载后，在function中使用

create or replace function getpy(s varchar2) return varchar2 as language java name 'test.PinyinUtil.getFirstLetter(java.lang.String) return java.lang.String';