17,377
社区成员
发帖
与我相关
我的任务
分享
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create or replace and compile java source named testname as
2 public class Test{
3 public static String create(String s) {
4 return s.length()+"";
5 }
6 }
7 /
Java 已创建。
SQL> create or replace function mycreate(h in varchar2) return varchar2 as
2 language java name 'Test.create(java.lang.String) return String';
3 /
函数已创建。
SQL>
SQL> select mycreate(lpad('0',2100,'1')) from dual;
MYCREATE(LPAD('0',2100,'1'))
----------------------------------------------------------------------------
2100
SQL>