I've wanted something like this for a while.. Hope this helps someone else...
Make a master detail report...
1. Click the reports tab.
2. Right click on "user defined reports" and select "add report"
3. Type "Java Source Object and Class Code" into the name field.
4. Make sure "Style" is set to "Table".
5. Paste this code into the "SQL" window.
select OBJECT_NAME, OBJECT_TYPE, to_char(created,'DD-MON-YYYY HH24:MI:SS') Created, to_char(LAST_DDL_TIME,'DD-MON-YYYY HH24:MI:SS') "Last DDL", STATUS
from user_objects
where object_type in ('JAVA SOURCE')
order by object_name
6. Click "Add child"
7. Make sure "Style" is set to "Code" in the child.
8. Paste the following code into the SQL window of the child.
select text from user_source where name = :OBJECT_NAME order by line
9. Click Apply..
10. Enjoy...
no semicolons after the sql....
Message was edited by:
slugo