PL/SQL code

From: Doron <doron_almog_at_msn.com>
Date: 20 Jul 2004 14:25:24 -0700
Message-ID: <995517bc.0407201325.16ac4e6a@posting.google.com>

Hi,

I have a piece of code (attached bellow) that grabs the names of several tables in my schema. I now want to grab a maximum value of one of the columns from these tables (same column name in all the tables). Is there any way other then spooling the output (as shown below) into a file and running that file?

As you can see from the code I'm a beginner at this so any help will be much appreciated.

Thanks,
Doron

Declare

CURSOR SITE_BASE_CUR IS select tdm_base_obj_id from tdm_db_site_ranges where object_id = (select object_id from tdm_db_site where tdm_name =

                                       (select global_name from

global_name));

site_base tdm_db_site_ranges.tdm_base_obj_id%type ;                                                                                                                                                                   

cursor up_tab is select table_name from tdm_class where class_id in (select class_id from tdm_last_object_id where object_id>0);

update_table tdm_class.table_name%type ;                                                                                                                                           

begin

open site_base_cur;
fetch site_base_cur into site_base;

open up_tab;
loop
fetch up_tab into update_table;                                                                                                                                 

exit when up_tab%notfound; dbms_output.put_line(‘select max(column_1) from' update_table); end loop;
end ; Received on Tue Jul 20 2004 - 16:25:24 CDT