解决方案 »
- win7 下安装oracle9i 提示“path的值不能超过1023字符”
- 求助写sql语句,各位达人来!
- 在PL SQL 中 用@D:/路径/test.sql,用这种方式导入SQl 的时候, 对SQl 文件的大小有限制吗 ?
- 求一个oracle 数据导入问题
- 谁与争锋-数据库管理工具OEM、i3的取舍
- 一个hql单表查询
- 非常急动态游标问题
- 关于select 语句中对某一属性求和(用sum吗?)
- oracle安装问题
- 关于oracle8.1.7的备份恢复?
- oracle存储过程中用并行高效的插入大数据
- 数据库字符集(ZHS16GBK)和客户端字符集(2%)是不同的,字符集转化可能会造成不可预期的后果
/* 文档中心的初始化脚本 */
DECLARE @ROW_EXISTS NUMBER(10, 0);
SET @ROW_EXISTS = 0;SELECT @ROW_EXISTS = count(*) FROM T_DOC_DOCTYPE WHERE F_ID = 10000 ;
IF(@ROW_EXISTS <= 0) THEN
INSERT INTO T_DOC_DOCTYPE (F_ID, F_PARENTID, F_NAME_en, F_NAME_zh_CN, F_NAME_zh_TW, F_SORT_INDEX, F_TYPE, F_COMMENT, F_NOT_NULL, F_IS_SHOW, F_REF_FIELD_NAME, F_FIELD_TYPE, F_SET_TYPE, F_FIELD_CONFIG, F_REF_ENTITY_PROPERTY, F_ENABLED) VALUES (10000, -1, NULL, '计价依据', NULL, 5, '0', NULL, 0, 0, NULL, '0', '0', NULL, NULL, 1);
END;
IF(@ROW_EXISTS <= 0) THEN
INSERT INTO T_DOC_DOCTYPE (F_ID, F_PARENTID, F_NAME_en, F_NAME_zh_CN, F_NAME_zh_TW, F_SORT_INDEX, F_TYPE, F_COMMENT, F_NOT_NULL, F_IS_SHOW, F_REF_FIELD_NAME, F_FIELD_TYPE, F_SET_TYPE, F_FIELD_CONFIG, F_REF_ENTITY_PROPERTY, F_ENABLED) VALUES (10001, 10000, '', '颁布单位', '', 0, '1', NULL, 1, 1, 'String1', '0', '0', NULL, NULL, 1);
END;
SELECT @ROW_EXISTS = count(*) FROM T_DOC_DOCTYPE WHERE F_ID = 10002 ;
IF(@ROW_EXISTS <= 0) THEN
INSERT INTO T_DOC_DOCTYPE (F_ID, F_PARENTID, F_NAME_en, F_NAME_zh_CN, F_NAME_zh_TW, F_SORT_INDEX, F_TYPE, F_COMMENT, F_NOT_NULL, F_IS_SHOW, F_REF_FIELD_NAME, F_FIELD_TYPE, F_SET_TYPE, F_FIELD_CONFIG, F_REF_ENTITY_PROPERTY, F_ENABLED) VALUES (10002, 10000, '', '颁布日期', '', 1, '1', NULL, 1, 1, 'DateTime1', '4', '4', NULL, NULL, 1);
END;
SELECT @ROW_EXISTS = count(*) FROM T_DOC_DOCTYPE WHERE F_ID = 10003 ;
IF(@ROW_EXISTS <= 0) THEN
INSERT INTO T_DOC_DOCTYPE (F_ID, F_PARENTID, F_NAME_en, F_NAME_zh_CN, F_NAME_zh_TW, F_SORT_INDEX, F_TYPE, F_COMMENT, F_NOT_NULL, F_IS_SHOW, F_REF_FIELD_NAME, F_FIELD_TYPE, F_SET_TYPE, F_FIELD_CONFIG, F_REF_ENTITY_PROPERTY, F_ENABLED) VALUES (10003, 10000, '', '省份', '', 2, '1', NULL, 1, 1, 'String2', '0', '0', NULL, NULL, 1);
END;
SELECT @ROW_EXISTS = count(*) FROM T_DOC_DOCTYPE WHERE F_ID = 10004 ;
IF(@ROW_EXISTS <= 0) THEN
INSERT INTO T_DOC_DOCTYPE (F_ID, F_PARENTID, F_NAME_en, F_NAME_zh_CN, F_NAME_zh_TW, F_SORT_INDEX, F_TYPE, F_COMMENT, F_NOT_NULL, F_IS_SHOW, F_REF_FIELD_NAME, F_FIELD_TYPE, F_SET_TYPE, F_FIELD_CONFIG, F_REF_ENTITY_PROPERTY, F_ENABLED) VALUES (10004, 10000, '', '是否有效', '', 3, '1', NULL, 1, 1, 'String3', '0', '1', '是,否', NULL, 1);
END;
SELECT @ROW_EXISTS = count(*) FROM T_DOC_DOCTYPE WHERE F_ID = 10005 ;
IF(@ROW_EXISTS <= 0) THEN
INSERT INTO T_DOC_DOCTYPE (F_ID, F_PARENTID, F_NAME_en, F_NAME_zh_CN, F_NAME_zh_TW, F_SORT_INDEX, F_TYPE, F_COMMENT, F_NOT_NULL, F_IS_SHOW, F_REF_FIELD_NAME, F_FIELD_TYPE, F_SET_TYPE, F_FIELD_CONFIG, F_REF_ENTITY_PROPERTY, F_ENABLED) VALUES (10005, 10000, NULL, '备注', NULL, 4, '1', NULL, 0, 0, 'Text1', '1', '2', NULL, NULL, 1);
END;
/****** Object: Table T_DOC_CUSTOM_COLUMN Script Date: 02/18/2014 14:46:13 ******/
UPDATE T_DOC_CUSTOM_COLUMN SET F_WIDTH=0 ,F_SORT_INDEX = 0,F_IS_SHOW=1 WHERE F_ID = 1;
UPDATE T_DOC_CUSTOM_COLUMN SET F_WIDTH=200 ,F_SORT_INDEX = 1,F_IS_SHOW=1 WHERE F_ID = 2;
UPDATE T_DOC_CUSTOM_COLUMN SET F_WIDTH=70 ,F_SORT_INDEX = 2,F_IS_SHOW=1 WHERE F_ID = 3;
UPDATE T_DOC_CUSTOM_COLUMN SET F_WIDTH=70 ,F_SORT_INDEX = 0,F_IS_SHOW=1 WHERE F_ID = 4;
UPDATE T_DOC_CUSTOM_COLUMN SET F_WIDTH=100 ,F_SORT_INDEX = 3,F_IS_SHOW=0 WHERE F_ID = 5;
UPDATE T_DOC_CUSTOM_COLUMN SET F_WIDTH=100 ,F_SORT_INDEX = 4,F_IS_SHOW=0 WHERE F_ID = 6;
UPDATE T_DOC_CUSTOM_COLUMN SET F_WIDTH=100 ,F_SORT_INDEX = 5,F_IS_SHOW=1 WHERE F_ID = 7;
UPDATE T_DOC_CUSTOM_COLUMN SET F_WIDTH=50 ,F_SORT_INDEX = 6,F_IS_SHOW=1 WHERE F_ID = 8;
UPDATE T_DOC_CUSTOM_COLUMN SET F_WIDTH=70 ,F_SORT_INDEX = 7,F_IS_SHOW=1 WHERE F_ID = 9;
UPDATE T_DOC_CUSTOM_COLUMN SET F_WIDTH=70 ,F_SORT_INDEX = 8,F_IS_SHOW=1 WHERE F_ID = 10;
/****** Object: Table [dbo].[T_DOC_OBJECT] Script Date: 02/18/2014 15:11:41 ******/SELECT @ROW_EXISTS = count(*) FROM T_DOC_OBJECT WHERE F_ID = 10152 ;
IF(@ROW_EXISTS <= 0) THEN
INSERT INTO T_DOC_OBJECT (F_ID, F_PARENTID, F_PLAT_FORMID, F_NAME_en, F_NAME_zh_CN, F_NAME_zh_TW, F_SORT_INDEX, F_TYPE, F_SUB_TYPE, F_USERID, F_PROJECTID, F_PROJECT_UNITID, F_PATH, F_KEY1, F_KEY2, F_UPLOADID, F_UPLOAD_NAME, F_UPLOAD_TIME, F_UPLOAD_DEPTID, F_UPLOAD_DEPT_NAME, F_MODIFIERID, F_MODIFIER_NAME, F_MODIFIER_TIME, F_MODIFIER_DEPTID, F_MODIFIER_DEPT_NAME, F_IS_DELETED, F_IS_SHOW_CHILD_FOLDER_DOC, F_IS_REQUIRE_CHECK, F_CHECKERID, F_CHECKER_NAME, F_CHECK_STATE, F_CHECK_REASON, F_DOC_CODE, F_DOC_SOURCE, F_DOC_KEYWORD, F_ABSTRACT, F_COMMENT, F_VALID_DATE, F_AUTHOR, F_FLOWID, F_IS_HISTORY_FLOW, F_ARCHIVED, F_ARCHIVE_CODE, F_DOC_CODE_TEMPLATE, F_DOC_TYPEID, F_SECRET_OBJECT_ID, F_REAL_DOC_ID, F_UPLOAD_FULL_DEPTID, F_MODIFIER_FULL_DEPTID, F_ARCHIVE_STORAGE_TIME, F_ARCHIVE_PAGES, F_COPIES, F_PROCESS_CODE, F_IS_DELETE_REQUIRE_CHECK, F_DELETE_STATE, F_EDITORID, F_EDITOR_NAME, F_EDITOR_FULL_DEPTID, F_EDITOR_DEPT_NAME, F_ARCHIVE_FILE_CREATE_TIME, F_ARCHIVE_PROCESS_CODE, F_ARCHIVE_PROCESS_NAME) VALUES (10152, 0, 0, NULL, '管理规范', NULL, 0, '5', '-1', -1, -1, -1, '/-1/0/', NULL, NULL, -1, 'SYSTEM', now(), NULL, NULL, -1, 'SYSTEM', now(), NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, now(), NULL, -1, 0, 0, NULL, '', 10000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 0, -1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
END;
SELECT @ROW_EXISTS = count(*) FROM T_DOC_OBJECT WHERE F_ID = 10153 ;
IF(@ROW_EXISTS <= 0) THEN
INSERT INTO T_DOC_OBJECT (F_ID, F_PARENTID, F_PLAT_FORMID, F_NAME_en, F_NAME_zh_CN, F_NAME_zh_TW, F_SORT_INDEX, F_TYPE, F_SUB_TYPE, F_USERID, F_PROJECTID, F_PROJECT_UNITID, F_PATH, F_KEY1, F_KEY2, F_UPLOADID, F_UPLOAD_NAME, F_UPLOAD_TIME, F_UPLOAD_DEPTID, F_UPLOAD_DEPT_NAME, F_MODIFIERID, F_MODIFIER_NAME, F_MODIFIER_TIME, F_MODIFIER_DEPTID, F_MODIFIER_DEPT_NAME, F_IS_DELETED, F_IS_SHOW_CHILD_FOLDER_DOC, F_IS_REQUIRE_CHECK, F_CHECKERID, F_CHECKER_NAME, F_CHECK_STATE, F_CHECK_REASON, F_DOC_CODE, F_DOC_SOURCE, F_DOC_KEYWORD, F_ABSTRACT, F_COMMENT, F_VALID_DATE, F_AUTHOR, F_FLOWID, F_IS_HISTORY_FLOW, F_ARCHIVED, F_ARCHIVE_CODE, F_DOC_CODE_TEMPLATE, F_DOC_TYPEID, F_SECRET_OBJECT_ID, F_REAL_DOC_ID, F_UPLOAD_FULL_DEPTID, F_MODIFIER_FULL_DEPTID, F_ARCHIVE_STORAGE_TIME, F_ARCHIVE_PAGES, F_COPIES, F_PROCESS_CODE, F_IS_DELETE_REQUIRE_CHECK, F_DELETE_STATE, F_EDITORID, F_EDITOR_NAME, F_EDITOR_FULL_DEPTID, F_EDITOR_DEPT_NAME, F_ARCHIVE_FILE_CREATE_TIME, F_ARCHIVE_PROCESS_CODE, F_ARCHIVE_PROCESS_NAME) VALUES (10153, 0, 0, NULL, '取费文件', NULL, 1, '5', '-1', -1, -1, -1, '/-1/0/', NULL, NULL, -1, 'SYSTEM', 0x0000A2D600EFE8CC, NULL, NULL, -1, 'SYSTEM', now(), NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, now(), NULL, -1, 0, 0, NULL, NULL, 10000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, -1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
END;
SELECT @ROW_EXISTS = count(*) FROM T_DOC_OBJECT WHERE F_ID = 10154 ;
IF(@ROW_EXISTS <= 0) THEN
INSERT INTO T_DOC_OBJECT (F_ID, F_PARENTID, F_PLAT_FORMID, F_NAME_en, F_NAME_zh_CN, F_NAME_zh_TW, F_SORT_INDEX, F_TYPE, F_SUB_TYPE, F_USERID, F_PROJECTID, F_PROJECT_UNITID, F_PATH, F_KEY1, F_KEY2, F_UPLOADID, F_UPLOAD_NAME, F_UPLOAD_TIME, F_UPLOAD_DEPTID, F_UPLOAD_DEPT_NAME, F_MODIFIERID, F_MODIFIER_NAME, F_MODIFIER_TIME, F_MODIFIER_DEPTID, F_MODIFIER_DEPT_NAME, F_IS_DELETED, F_IS_SHOW_CHILD_FOLDER_DOC, F_IS_REQUIRE_CHECK, F_CHECKERID, F_CHECKER_NAME, F_CHECK_STATE, F_CHECK_REASON, F_DOC_CODE, F_DOC_SOURCE, F_DOC_KEYWORD, F_ABSTRACT, F_COMMENT, F_VALID_DATE, F_AUTHOR, F_FLOWID, F_IS_HISTORY_FLOW, F_ARCHIVED, F_ARCHIVE_CODE, F_DOC_CODE_TEMPLATE, F_DOC_TYPEID, F_SECRET_OBJECT_ID, F_REAL_DOC_ID, F_UPLOAD_FULL_DEPTID, F_MODIFIER_FULL_DEPTID, F_ARCHIVE_STORAGE_TIME, F_ARCHIVE_PAGES, F_COPIES, F_PROCESS_CODE, F_IS_DELETE_REQUIRE_CHECK, F_DELETE_STATE, F_EDITORID, F_EDITOR_NAME, F_EDITOR_FULL_DEPTID, F_EDITOR_DEPT_NAME, F_ARCHIVE_FILE_CREATE_TIME, F_ARCHIVE_PROCESS_CODE, F_ARCHIVE_PROCESS_NAME) VALUES (10154, 0, 0, NULL, '信息价', NULL, 2, '5', '-1', -1, -1, -1, '/-1/0/', NULL, NULL, -1, 'SYSTEM', now(), NULL, NULL, -1, 'SYSTEM', now(), NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, now(), NULL, -1, 0, 0, NULL, NULL, 10000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, -1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
END;
SELECT @ROW_EXISTS = count(*) FROM T_DOC_OBJECT WHERE F_ID = 10155 ;
IF(@ROW_EXISTS <= 0) THEN
INSERT INTO T_DOC_OBJECT (F_ID, F_PARENTID, F_PLAT_FORMID, F_NAME_en, F_NAME_zh_CN, F_NAME_zh_TW, F_SORT_INDEX, F_TYPE, F_SUB_TYPE, F_USERID, F_PROJECTID, F_PROJECT_UNITID, F_PATH, F_KEY1, F_KEY2, F_UPLOADID, F_UPLOAD_NAME, F_UPLOAD_TIME, F_UPLOAD_DEPTID, F_UPLOAD_DEPT_NAME, F_MODIFIERID, F_MODIFIER_NAME, F_MODIFIER_TIME, F_MODIFIER_DEPTID, F_MODIFIER_DEPT_NAME, F_IS_DELETED, F_IS_SHOW_CHILD_FOLDER_DOC, F_IS_REQUIRE_CHECK, F_CHECKERID, F_CHECKER_NAME, F_CHECK_STATE, F_CHECK_REASON, F_DOC_CODE, F_DOC_SOURCE, F_DOC_KEYWORD, F_ABSTRACT, F_COMMENT, F_VALID_DATE, F_AUTHOR, F_FLOWID, F_IS_HISTORY_FLOW, F_ARCHIVED, F_ARCHIVE_CODE, F_DOC_CODE_TEMPLATE, F_DOC_TYPEID, F_SECRET_OBJECT_ID, F_REAL_DOC_ID, F_UPLOAD_FULL_DEPTID, F_MODIFIER_FULL_DEPTID, F_ARCHIVE_STORAGE_TIME, F_ARCHIVE_PAGES, F_COPIES, F_PROCESS_CODE, F_IS_DELETE_REQUIRE_CHECK, F_DELETE_STATE, F_EDITORID, F_EDITOR_NAME, F_EDITOR_FULL_DEPTID, F_EDITOR_DEPT_NAME, F_ARCHIVE_FILE_CREATE_TIME, F_ARCHIVE_PROCESS_CODE, F_ARCHIVE_PROCESS_NAME) VALUES (10155, 0, 0, NULL, '定额', NULL, 3, '5', '-1', -1, -1, -1, '/-1/0/', NULL, NULL, -1, 'SYSTEM', now(), NULL, NULL, -1, 'SYSTEM', now(), NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, now(), NULL, -1, 0, 0, NULL, NULL, 10000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, -1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
END;
IF(@ROW_EXISTS <= 0) THEN
INSERT INTO T_DOC_OBJECT (F_ID, F_PARENTID, F_PLAT_FORMID, F_NAME_en, F_NAME_zh_CN, F_NAME_zh_TW, F_SORT_INDEX, F_TYPE, F_SUB_TYPE, F_USERID, F_PROJECTID, F_PROJECT_UNITID, F_PATH, F_KEY1, F_KEY2, F_UPLOADID, F_UPLOAD_NAME, F_UPLOAD_TIME, F_UPLOAD_DEPTID, F_UPLOAD_DEPT_NAME, F_MODIFIERID, F_MODIFIER_NAME, F_MODIFIER_TIME, F_MODIFIER_DEPTID, F_MODIFIER_DEPT_NAME, F_IS_DELETED, F_IS_SHOW_CHILD_FOLDER_DOC, F_IS_REQUIRE_CHECK, F_CHECKERID, F_CHECKER_NAME, F_CHECK_STATE, F_CHECK_REASON, F_DOC_CODE, F_DOC_SOURCE, F_DOC_KEYWORD, F_ABSTRACT, F_COMMENT, F_VALID_DATE, F_AUTHOR, F_FLOWID, F_IS_HISTORY_FLOW, F_ARCHIVED, F_ARCHIVE_CODE, F_DOC_CODE_TEMPLATE, F_DOC_TYPEID, F_SECRET_OBJECT_ID, F_REAL_DOC_ID, F_UPLOAD_FULL_DEPTID, F_MODIFIER_FULL_DEPTID, F_ARCHIVE_STORAGE_TIME, F_ARCHIVE_PAGES, F_COPIES, F_PROCESS_CODE, F_IS_DELETE_REQUIRE_CHECK, F_DELETE_STATE, F_EDITORID, F_EDITOR_NAME, F_EDITOR_FULL_DEPTID, F_EDITOR_DEPT_NAME, F_ARCHIVE_FILE_CREATE_TIME, F_ARCHIVE_PROCESS_CODE, F_ARCHIVE_PROCESS_NAME) VALUES (10158, 10153, 0, NULL, '行业', NULL, 0, '5', '-1', -1, -1, -1, '/-1/0/10153/', NULL, NULL, -1, 'SYSTEM', now(), NULL, NULL, -1, 'SYSTEM', now(), NULL, NULL, 0, 0, 0, NULL, NULL, -1, NULL, NULL, NULL, NULL, NULL, NULL, now(), NULL, -1, 0, 0, NULL, NULL, 10000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, -1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
END;
SELECT @ROW_EXISTS = count(*) FROM T_DOC_OBJECT WHERE F_ID = 10160 ;
IF(@ROW_EXISTS <= 0) THEN
INSERT INTO T_DOC_OBJECT (F_ID, F_PARENTID, F_PLAT_FORMID, F_NAME_en, F_NAME_zh_CN, F_NAME_zh_TW, F_SORT_INDEX, F_TYPE, F_SUB_TYPE, F_USERID, F_PROJECTID, F_PROJECT_UNITID, F_PATH, F_KEY1, F_KEY2, F_UPLOADID, F_UPLOAD_NAME, F_UPLOAD_TIME, F_UPLOAD_DEPTID, F_UPLOAD_DEPT_NAME, F_MODIFIERID, F_MODIFIER_NAME, F_MODIFIER_TIME, F_MODIFIER_DEPTID, F_MODIFIER_DEPT_NAME, F_IS_DELETED, F_IS_SHOW_CHILD_FOLDER_DOC, F_IS_REQUIRE_CHECK, F_CHECKERID, F_CHECKER_NAME, F_CHECK_STATE, F_CHECK_REASON, F_DOC_CODE, F_DOC_SOURCE, F_DOC_KEYWORD, F_ABSTRACT, F_COMMENT, F_VALID_DATE, F_AUTHOR, F_FLOWID, F_IS_HISTORY_FLOW, F_ARCHIVED, F_ARCHIVE_CODE, F_DOC_CODE_TEMPLATE, F_DOC_TYPEID, F_SECRET_OBJECT_ID, F_REAL_DOC_ID, F_UPLOAD_FULL_DEPTID, F_MODIFIER_FULL_DEPTID, F_ARCHIVE_STORAGE_TIME, F_ARCHIVE_PAGES, F_COPIES, F_PROCESS_CODE, F_IS_DELETE_REQUIRE_CHECK, F_DELETE_STATE, F_EDITORID, F_EDITOR_NAME, F_EDITOR_FULL_DEPTID, F_EDITOR_DEPT_NAME, F_ARCHIVE_FILE_CREATE_TIME, F_ARCHIVE_PROCESS_CODE, F_ARCHIVE_PROCESS_NAME) VALUES (10160, 10153, 0, NULL, '地方', NULL, 1, '5', '-1', -1, -1, -1, '/-1/0/10153/', NULL, NULL, -1, 'SYSTEM', now(), NULL, NULL, -1, 'SYSTEM', now(), NULL, NULL, 0, 0, 0, NULL, NULL, -1, NULL, NULL, NULL, NULL, NULL, NULL, now(), NULL, -1, 0, 0, NULL, NULL, 10000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, -1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
END;