where object_name = 'A' and OBJECT_TYPE = 'TABLE PARTITION')。获取DATA_OBJECT_ID,然后 select * from A partition(DATAOBJ_TO_PARTITION(A, p.DATA_OBJECT_ID)来处理。
oracle跳出当前循环是用goto,直接跳出使用exit;
declare
cursor cur_p is(
select DATA_OBJECT_ID
from user_objects t
where object_name = 'A'
and OBJECT_TYPE = 'TABLE PARTITION');
begin
for p in cur_p loop
declare
cursor cur is(
select /*+ leading(c) */
*
from A partition(DATAOBJ_TO_PARTITION(A, p.DATA_OBJECT_ID));
v_table cur%ROWTYPE;
num integer;
v_sqlerrm varchar2(1000);
begin
end;
end loop;
end;