Using Java objects in Oracle

1. Write a Java object and save it in C:/Hello. Java

2. loadjava-user Scott/tiger @ 223 hello. java, set hello. java is added to the database. If the source code is added, we can see from javasource that if the class is loaded, it cannot be seen from javasource.

3. query the loaded object.

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
Certificate ---------- --------- ----------- -------- certificate -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Hello 49 0 interface Public No hello. Java/lang/Object-

4. loadjava can load class, jar, resource, Properties

5. After loading, use

Create or replace function getpy (s varchar2) return varchar2 as language Java name 'test. pinyinutil. getfirstletter (Java. Lang. String) return java. Lang. string ';