PL/SQL code
Date: 20 Jul 2004 14:25:24 -0700
Message-ID: <995517bc.0407201325.16ac4e6a_at_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,
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 =
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;
open up_tab;
Doron
(select global_name from
global_name));
fetch site_base_cur into site_base;
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 - 23:25:24 CEST