PL/SQL Table-to-Java Bean (and Data to Java Bean Manager) generator - useful for data driven demos without database - AMIS, Data Driven Blog - Oracle & Microsoft Azure
dbms_metadata tips
Creating Data Sets
plsql - How do I get column datatype in Oracle with PL-SQL with low privileges? - Stack Overflow
Using Dynamic SQL
DBMS_SQL , 1 of 20
Oracle execute dynamic sql select script and return tabular data - Stack Overflow