Re: Procedure to show and spool all the results

Thanks Rene and DA.
However, it seems pretty complicated. Is there any other solution to handle this?

Or, if I simply want to display all results on the screen(no spooling), how can I achieve this?
Seems if I just use dbms_output.putline, it only displays the queries only without the results.

select * from customer where customer_id=xx;
select * from order where customer_id=xx;
select * from product where product_id=yy;

Thanks Received on Wed Mar 23 2005 - 12:01:55 CST