1. execute DDL
2. we need to concatenate query about the table name and condition.
we have three method to execute dynamic query
1.execute immediate
2. ref cursor
3.dbms_sql
When and how to use dynamic Query
原文:http://www.cnblogs.com/aimin/p/6429277.html