高手指点一下，本人搞晕了！！

Question

具体一点嘛！select子句写出来啊

Answer 1

本人想在存储过程中写一个建表的脚本，脚本如下：
           CREATE  TABLE TB_DWJBXX 
                      ( DWID00 CHAR(10) PRIMARY KEY,        
                        DAHAO0 CHAR(10) NOT NULL,           
                        DWDMA0 CHAR(10) NOT NULL,           
                        DWMC00 VARCHAR2(50) NOT NULL,       
                        YLJZRQ CHAR(8),                     
                        GDYLJZ CHAR(8),                     
                        ZZJGDM CHAR(10)     NOT NULL,      
                        SJDWDM CHAR(10),                   
                        SJDWID CHAR(10),                    
                        ZGBMDM CHAR(9),                     
                        ZGBMMC VARCHAR2(50),               
                        DWLX00 CHAR(2) NOT NULL,            
                        CZLBIE CHAR(1) DEFAULT '1' NOT NULL, 
                        JJLX00 CHAR(3) NOT NULL,            
                        GSBXLB CHAR(1) NOT NULL,           
                        LSGXI0 CHAR(2) NOT NULL,            
                        FRDB00 CHAR(16),                    
                        FRSFZH CHAR(18),                    
                        YZBMA0 CHAR(6),                     
                        LXDHUA CHAR(20),                    
                        ZGYUAN CHAR(16),                    
                        ZGYSFZ CHAR(18),                    
                        ZGYXM0 CHAR(20),                    
                        ZGYBM0 VARCHAR2(50),                
                        ZGYDH0 VARCHAR2(20),                
                        JFYHMC VARCHAR2(80) NOT NULL,       
                        JFYHH0 VARCHAR2(40) NOT NULL,       
                        JFYHHM VARCHAR2(50) NOT NULL,       
                        JFYHZH VARCHAR2(40) NOT NULL,       
                        ZFYHMC VARCHAR2(80),                
                        ZFYHH0 VARCHAR2(40),                
                        ZFYHHM VARCHAR2(50),               
                        ZFYHZH VARCHAR2(40),                
                        GSDJHM VARCHAR2(20),                
                        GSDJRQ CHAR(8),                     
                        GSJZRQ CHAR(8),                     
                        PZCLDW VARCHAR2(50),                
                        PZWHAO VARCHAR2(20),               
                        SWHAO0 VARCHAR2(40),                
                        SWJGBH CHAR(8),                     
                        SWJGMC VARCHAR2(50),                
                        SSHYE0 CHAR(2) NOT NULL,            
                        SZCSHI CHAR(6) NOT NULL,            
                        HYDMA0 CHAR(5),                     
                        ZXCSBZ CHAR(6),                     
                        DYZXBZ CHAR(1),                     
                        DQBHAO  CHAR(2) NOT NULL,                  
                        FZXBH0  CHAR(2) NOT NULL,                 
                        SSXT00  CHAR(2) NOT NULL,                 
                        TXZSFS  CHAR(1) DEFAULT '0',               
                        YWZJBZ  CHAR(1) DEFAULT '0',              
                        YWZTAI  CHAR(1) DEFAULT '1',               
                        JBREN0  CHAR(16) NOT NULL,                 
                        JBRQI0  CHAR(8)  NOT NULL,                 
                        SHREN0  CHAR(16),                          
                        SHRQI0  CHAR(8),                           
                        SPREN0  CHAR(16),                          
                        DWZTAI  CHAR(1) DEFAULT '1',               
                        SPRQI0  CHAR(8),                           
                       );
在存储过程中怎么也不执行，哪位高手给指点一下什么原因，类似创建表这样的存储过程到底该怎么写
谢谢！！

Answer 2

把这个存放到一个变量中，然后execute immediate v_sql;
如：
  execute immediate 'create table testaaa (aa varchar2(20))';

Answer 3

不过要赋予用户create any table to 当前用户，否则不能进行创建，会办权限不足，即使你是dba角色也不行，因为在过程中对表的操作必须 显式赋予权限!