如何建立Java預存程序

一個建立使用java 預存程序的例子:

create or replace and compile
java source
named "MyTimestamp"
as
import java.lang.String;
import java.sql.Timestamp;
public class MyTimestamp
{
    public static String getTimestamp()
   {
     return(new Timestamp(System.currentTimeMillis())).toString();
   }
};
/
--註：注意java的文法，注意大小寫

create or replace function my_timestamp return varchar2
as language java
name 'MyTimestamp.getTimestamp() return java.lang.String';
/

SQL>select my_timestamp,to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') ORACLE_TIME from dual;

MY_TIMESTAMP             ORACLE_TIME

------------------------ -------------------

2003-03-17 19:15:59.688  2003-03-17 19:15:59