1.写java代码
create or replace and compile java source named hw as
import java.util.Date;
public class Hello{
public static Date getDate(){
Date today = new Date();
return today;
}
}
2.写oracle function
CREATE OR REPLACE FUNCTION HW_GETDATE
RETURN VARCHAR2 IS LANGUAGE JAVA NAME 'Hello.getDate() return java.util.Date';
3.在sql中使用该函数
SELECT HW_GETDATE FROM DUAL;