EBS: JAVA SOURCE创建后再查看源代码

 

EBS : JAVA SOURCE创建后再查看源代码

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14

DECLARE CURSOR C1 IS SELECT US.NAME, TYPE, LINE, TEXT   FROM USER_SOURCE US   WHERE 1=1    AND NAME LIKE 'HELLO'  -- JAVA源名称    AND TYPE LIKE 'JAVA SOURCE'-- SOURCE'    ORDER BY NAME,TYPE,LINE; BEGIN   DBMS_OUTPUT.PUT_LINE('create or replace and compile java source named '|| 'HELLO' ||' as ');   FOR R1 IN C1 LOOP     DBMS_OUTPUT.PUT_LINE( R1.TEXT);   END LOOP; END;