批量打印查询条件

批量打印查询条件
例如：

select * from  user_channel_info_0-user_channel_info_99 where channel_id=2 or channel_id=4 ;

可以新建一个存储过程，打印查询条件：

create or replace procedure test_002 is
vSql varchar2(2000);
vTable varchar2(50);
vgrant varchar2(100);
begin
  vgrant:='grant create table to testuser';
  execute immediate vgrant;

for m in 0..99 loop

   vTable := 'user_channel_info_'||m;
    vSql := 'select * from  '|| vTable ||' where channel_id=2 or channel_id=4 ; ';
    dbms_output.put_line(vSql);
  --execute immediate vSql;
  end loop;
end test_002;