如何写一个批量建表的sql

declare i int; declare v_sql varchar(512); set i=0; while (i<100) do set v_sql='create table goodstatus_data_list_'||to_char((date('2016-09-11')+i day),'yyyymmdd')('||column_list||')'; execute immediate v_sql; set i=i+1; end while;