在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';