View java class source in oracle database

By admin

View java class source in oracle database
java class code that is compiled in database
java class is compiled successfully and is valid
query java object in Oracle database

Click HERE for steps to compile java object in Oracle database

SQL Querysql
1--Run below query to check if the java class is compiled successfully and is valid.
2SELECT *
3FROM dba_objects
4WHERE object_type IN ('JAVA SOURCE')
5and object_name like '%TEST_JAVA_PKG%';
6
7
8
9--Run below query to view the java class code that is compiled in database
10SELECT * FROM USER_SOURCE
11WHERE TYPE = 'JAVA SOURCE'
12AND NAME like '%TEST_JAVA_PKG%'
13order by line;

Related posts: