Select all the Rows ........ !!!!!

Dear Friends,

I have writted PL/SQL programme for select all the records from all the tables of one particular user.

It says PL/SQL sucessfully completed but, it did not written any output.

Could any suggest a better procedure.


SET SERVEROUTPUT ON
declare
t varchar2(30);
begin
for t in (select table_name from user_tables) loop
execute immediate 'select * from ' || t.table_name;
end loop;
end;




Thanks in advance

gandhi