Oracle 动态创建表和表名

http://blog.csdn.net/pingdan_yang/article/details/6654992

下面事例为根据当前的年月，动态创建数据库表：

create or replace procedure Syntable  is
 tablename varchar2(50);
begin
tablename := to_char(sysdate,'yyyy');
tablename := 'Y'||tablename;
tablename := tablename||'M'||to_char(sysdate,'MM');
 execute immediate ('  create table '|| tablename||' (  username varchar2(20))');
end ;