oracle 动态SQL

declare
 tablename varchar2(64);
 r_name  varchar2(256);
 shop_id number;
 sql_str varchar2(500);
begin
  tablename:='dp_shop';
  shop_id:=838113;
  execute immediate 'select name  from '||tablename||' r where r.shop_id=:1' into r_name using shop_id; 
  dbms_output.put_line(r_name);
end;

更多细节：http://blog.sina.com.cn/s/blog_63972ba20100wuqd.html