You would like output like this:
ops$tkyte@ORA920> exec print_table( 'select * from dept' ); DEPTNO : 10 DNAME : ACCOUNTING LOC : NEW YORK ----------------- DEPTNO : 20 DNAME : RESEARCH LOC : DALLAS ----------------- DEPTNO : 30 DNAME : SALES LOC : CHICAGO ----------------- DEPTNO : 40 DNAME : OPERATIONS LOC : BOSTON ----------------- PL/SQL procedure successfully completed.in sqlplus -- how can you do that? well -- click here: http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1035431863958 and grab the code for print_table...