如题 求高人 指点
execute immediate 'create table CUST_TEMP_PLY_BASE
(
C_PLY_NO nvarchar2(100),
C_ORIG_FLG int,
C_ORIG_PLY_NO nvarchar2(100),
C_PROD_NO nvarchar2(20),
C_DPT_CDE nvarchar2(100),
C_SLS_CDE nvarchar2(100),
c_oper_cde nvarchar2(100),
T_INSRNC_BGN_TM date,
T_INSRNC_END_TM date
)';
execute immediate 'alter table CUST_TEMP_PLY_BASE
add constraint PK_TEMP_PLY_PK primary key (C_PLY_NO)
using index
tablespace CRM_CLEAN
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 768K
minextents 1
maxextents unlimited
)';
add constraint PK_TEMP_PLY_PK primary key (C_PLY_NO) ------创建主键,指定索引表空间
using index
tablespace CRM_CLEAN
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 768K
minextents 1
maxextents unlimited
)
(
C_PLY_NO nvarchar2(100),
C_ORIG_FLG int,
C_ORIG_PLY_NO nvarchar2(100),
C_PROD_NO nvarchar2(20),
C_DPT_CDE nvarchar2(100),
C_SLS_CDE nvarchar2(100),
c_oper_cde nvarchar2(100),
T_INSRNC_BGN_TM date,
T_INSRNC_END_TM date
)';
execute immediate 'alter table CUST_TEMP_PLY_BASE
add constraint PK_TEMP_PLY_PK primary key (C_PLY_NO)---创建增加主键了
using index
tablespace CRM_CLEAN
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 768K
minextents 1
maxextents unlimited
)';
alter table CUST_TEMP_PLY_BASE
add constraint PK_TEMP_PLY_PK primary key (C_PLY_NO);execute immediate 这个命令在存储过程中是执行某某命令的意思,参数为字符串语句。