动态SQL指定分区名参数

SQL> ed
已写入 file afiedt.buf

1 create or replace procedure partition_name(par_name in varchar2)
2 is
3 v_sql varchar2(4000);
4 row_count number;
5 begin
6 v_sql :='select count(*) from awen_date partition('||par_name||')';
7 execute immediate v_sql into row_count;
8 dbms_output.put_line('The count row is '||row_count);
9* end partition_name;
SQL> /

过程已创建。

SQL> exec partition_name('part_1');
The count row is 2

PL/SQL 过程已成功完成。