哪位朋友有过这方面的经验没?我的SQL脚本是通过POWERDESGIN创建的
spool newmode.logprompt
prompt Creating table ALLOWSTANDARD
prompt ============================
prompt
create table ALLOWSTANDARD
(
SCHOOLNUM VARCHAR2(20) not null,
CLASSCODE VARCHAR2(20),
SCHOOLCODE VARCHAR2(10) not null,
PROVINCE VARCHAR2(20),
CITY VARCHAR2(20),
DISTRICT VARCHAR2(20),
GRADE VARCHAR2(10),
ASSISTANCEKIND VARCHAR2(20),
ASSISMONEY NUMBER(20)
)
;
alter table ALLOWSTANDARD
add primary key (SCHOOLCODE, SCHOOLNUM);
prompt
prompt Creating table UNIT_PERSON_GUIDELINE
prompt ====================================
prompt
create table UNIT_PERSON_GUIDELINE
(
RJGDZCZE_3 NUMBER(12,10),
RJTDZYMJ_4 NUMBER(12,10),
RJFWJZWMJ_5 NUMBER(12,10),
RJZGSSMJ_6 NUMBER(12,10),
RJZCZE_1 NUMBER(12,10),
RJGYZCZE_2 NUMBER(12,10),
RJZCZE_7 NUMBER(12,10),
RJGYZCZE_8 NUMBER(12,10),
RJGDZCZE_9 NUMBER(12,10),
RJTDZYMJ_10 NUMBER(12,10),
RJFWJZWMJ_11 NUMBER(12,10),
RJBGYFMJ_12 NUMBER(12,10),
ZCFZL_13 NUMBER(12,10),
GDZCZZZCBL_14 NUMBER(12,10),
JYXZCZZZCBL_15 NUMBER(12,10),
JYXZCZGYZCBL_16 NUMBER(12,10),
UNITCODE VARCHAR2(30) not null,
ID NUMBER(8) not null
)
;
comment on column UNIT_PERSON_GUIDELINE.RJGDZCZE_3
is '人均固定资产总额_年末';
comment on column UNIT_PERSON_GUIDELINE.RJTDZYMJ_4
is '人均土地占用面积_年末';
comment on column UNIT_PERSON_GUIDELINE.RJFWJZWMJ_5
is '人均房屋建筑物面积_年末';
comment on column UNIT_PERSON_GUIDELINE.RJZGSSMJ_6
is '人均职工宿舍面积_年末';
comment on column UNIT_PERSON_GUIDELINE.RJZCZE_1
is '人均资产总额_年末';
comment on column UNIT_PERSON_GUIDELINE.RJGYZCZE_2
is '人均国有资产总额_年末';
comment on column UNIT_PERSON_GUIDELINE.RJZCZE_7
is '人均资产总额_在职';
comment on column UNIT_PERSON_GUIDELINE.RJGYZCZE_8
is '人均国有资产总额_在职';
comment on column UNIT_PERSON_GUIDELINE.RJGDZCZE_9
is '人均固定资产总额_在职';
comment on column UNIT_PERSON_GUIDELINE.RJTDZYMJ_10
is '人均土地占用面积_在职';
comment on column UNIT_PERSON_GUIDELINE.RJFWJZWMJ_11
is '人均房屋建筑物面积_在职';
comment on column UNIT_PERSON_GUIDELINE.RJBGYFMJ_12
is '人均办公用房面积_在职';
comment on column UNIT_PERSON_GUIDELINE.ZCFZL_13
is '资产负债率_其他';
comment on column UNIT_PERSON_GUIDELINE.GDZCZZZCBL_14
is '固定资产占总资产比率_其他';
comment on column UNIT_PERSON_GUIDELINE.JYXZCZZZCBL_15
is '经营性资产占总资产比率_其他';
comment on column UNIT_PERSON_GUIDELINE.JYXZCZGYZCBL_16
is '经营性资产占国有资产比率';
comment on column UNIT_PERSON_GUIDELINE.UNITCODE
is '机构组织代码';
alter table UNIT_PERSON_GUIDELINE
add constraint P_UID_KEY primary key (ID);
alter table UNIT_PERSON_GUIDELINE
add constraint P_U_UK unique (UNITCODE);
prompt
prompt Creating sequence TEST_ID
prompt ==================================
prompt
create sequence TTEST_ID
minvalue 1
maxvalue 999999999999999999999999999
start with 441
increment by 1
cache 20;
spool off这就是脚本的一部分内容 如果自己解析就太麻烦了 哪位朋友能提供我解决方法啊 谢谢
spool newmode.logprompt
prompt Creating table ALLOWSTANDARD
prompt ============================
prompt
create table ALLOWSTANDARD
(
SCHOOLNUM VARCHAR2(20) not null,
CLASSCODE VARCHAR2(20),
SCHOOLCODE VARCHAR2(10) not null,
PROVINCE VARCHAR2(20),
CITY VARCHAR2(20),
DISTRICT VARCHAR2(20),
GRADE VARCHAR2(10),
ASSISTANCEKIND VARCHAR2(20),
ASSISMONEY NUMBER(20)
)
;
alter table ALLOWSTANDARD
add primary key (SCHOOLCODE, SCHOOLNUM);
prompt
prompt Creating table UNIT_PERSON_GUIDELINE
prompt ====================================
prompt
create table UNIT_PERSON_GUIDELINE
(
RJGDZCZE_3 NUMBER(12,10),
RJTDZYMJ_4 NUMBER(12,10),
RJFWJZWMJ_5 NUMBER(12,10),
RJZGSSMJ_6 NUMBER(12,10),
RJZCZE_1 NUMBER(12,10),
RJGYZCZE_2 NUMBER(12,10),
RJZCZE_7 NUMBER(12,10),
RJGYZCZE_8 NUMBER(12,10),
RJGDZCZE_9 NUMBER(12,10),
RJTDZYMJ_10 NUMBER(12,10),
RJFWJZWMJ_11 NUMBER(12,10),
RJBGYFMJ_12 NUMBER(12,10),
ZCFZL_13 NUMBER(12,10),
GDZCZZZCBL_14 NUMBER(12,10),
JYXZCZZZCBL_15 NUMBER(12,10),
JYXZCZGYZCBL_16 NUMBER(12,10),
UNITCODE VARCHAR2(30) not null,
ID NUMBER(8) not null
)
;
comment on column UNIT_PERSON_GUIDELINE.RJGDZCZE_3
is '人均固定资产总额_年末';
comment on column UNIT_PERSON_GUIDELINE.RJTDZYMJ_4
is '人均土地占用面积_年末';
comment on column UNIT_PERSON_GUIDELINE.RJFWJZWMJ_5
is '人均房屋建筑物面积_年末';
comment on column UNIT_PERSON_GUIDELINE.RJZGSSMJ_6
is '人均职工宿舍面积_年末';
comment on column UNIT_PERSON_GUIDELINE.RJZCZE_1
is '人均资产总额_年末';
comment on column UNIT_PERSON_GUIDELINE.RJGYZCZE_2
is '人均国有资产总额_年末';
comment on column UNIT_PERSON_GUIDELINE.RJZCZE_7
is '人均资产总额_在职';
comment on column UNIT_PERSON_GUIDELINE.RJGYZCZE_8
is '人均国有资产总额_在职';
comment on column UNIT_PERSON_GUIDELINE.RJGDZCZE_9
is '人均固定资产总额_在职';
comment on column UNIT_PERSON_GUIDELINE.RJTDZYMJ_10
is '人均土地占用面积_在职';
comment on column UNIT_PERSON_GUIDELINE.RJFWJZWMJ_11
is '人均房屋建筑物面积_在职';
comment on column UNIT_PERSON_GUIDELINE.RJBGYFMJ_12
is '人均办公用房面积_在职';
comment on column UNIT_PERSON_GUIDELINE.ZCFZL_13
is '资产负债率_其他';
comment on column UNIT_PERSON_GUIDELINE.GDZCZZZCBL_14
is '固定资产占总资产比率_其他';
comment on column UNIT_PERSON_GUIDELINE.JYXZCZZZCBL_15
is '经营性资产占总资产比率_其他';
comment on column UNIT_PERSON_GUIDELINE.JYXZCZGYZCBL_16
is '经营性资产占国有资产比率';
comment on column UNIT_PERSON_GUIDELINE.UNITCODE
is '机构组织代码';
alter table UNIT_PERSON_GUIDELINE
add constraint P_UID_KEY primary key (ID);
alter table UNIT_PERSON_GUIDELINE
add constraint P_U_UK unique (UNITCODE);
prompt
prompt Creating sequence TEST_ID
prompt ==================================
prompt
create sequence TTEST_ID
minvalue 1
maxvalue 999999999999999999999999999
start with 441
increment by 1
cache 20;
spool off这就是脚本的一部分内容 如果自己解析就太麻烦了 哪位朋友能提供我解决方法啊 谢谢
SoftDN.com, 提供免费的项目管理平台:SVN仓库、需求管理、BUG跟踪、任务管理、在线论坛、网站空间、项目存储及完整的备份等。欢迎网友光临建立项目,开创自己的梦想。
地址:http://www.softdn.com http://www.softdn.cn