存储过程的运用之print_table
SQL> set serverout on size 100000SQL> select * from a; ID COL------ ----- 1 AA 2 bb 3 cc SQL> exec print_table('select * from a'); ID : 1COL : AA-----------------ID : 2COL : bb-----------------ID : 3COL : cc----------------- PL/SQL procedure successfully completed