syscode.sql

关于oracle和sql的书籍和ppt教程,非常好,本人珍藏品

insert into dk_sys_code(lxdm,dm,dmmc) values('01',		'01',	'超级用户');
insert into dk_sys_code(lxdm,dm,dmmc) values('01',		'02',	'管理员');
insert into dk_sys_code(lxdm,dm,dmmc) values('01',		'03',	'操作员');
		
insert into dk_sys_code(lxdm,dm,dmmc) values('02',		'00',	'中心' );
insert into dk_sys_code(lxdm,dm,dmmc) values('02',		'01',	'中国银行');
insert into dk_sys_code(lxdm,dm,dmmc) values('02',		'02',	'建设银行');
insert into dk_sys_code(lxdm,dm,dmmc) values('02',		'03',	'农业银行');

insert into dk_sys_code(lxdm,dm,dmmc) values('03',		'01', 	'机关');
insert into dk_sys_code(lxdm,dm,dmmc) values('03',		'02',	'事业单位');
insert into dk_sys_code(lxdm,dm,dmmc) values('03',		'03',	'全民');
insert into dk_sys_code(lxdm,dm,dmmc) values('03',		'04',	'集体');
insert into dk_sys_code(lxdm,dm,dmmc) values('03',		'05',	'私营');
insert into dk_sys_code(lxdm,dm,dmmc) values('03',		'06',	'三资');
insert into dk_sys_code(lxdm,dm,dmmc) values('03',		'07',	'股份制');
insert into dk_sys_code(lxdm,dm,dmmc) values('03',		'08',	'个体');
insert into dk_sys_code(lxdm,dm,dmmc) values('03',		'09',	'其它');

insert into dk_sys_code(lxdm,dm,dmmc) values('04',		'01',	'小学以下');
insert into dk_sys_code(lxdm,dm,dmmc) values('04',		'02',	'小学');
insert into dk_sys_code(lxdm,dm,dmmc) values('04',		'03',	'初中');
insert into dk_sys_code(lxdm,dm,dmmc) values('04',		'04',	'高中');
insert into dk_sys_code(lxdm,dm,dmmc) values('04',		'05',	'大专');
insert into dk_sys_code(lxdm,dm,dmmc) values('04',		'06',	'本科');
insert into dk_sys_code(lxdm,dm,dmmc) values('04',		'07',	'硕士');
insert into dk_sys_code(lxdm,dm,dmmc) values('04',		'08',	'博士');
insert into dk_sys_code(lxdm,dm,dmmc) values('04',		'09',	'博士以上');

insert into dk_sys_code(lxdm,dm,dmmc) values('05',		'01',	'一次付清');
insert into dk_sys_code(lxdm,dm,dmmc) values('05',		'02',	'等额本息');
insert into dk_sys_code(lxdm,dm,dmmc) values('05',		'03',	'等额本金');
    
insert into dk_sys_code(lxdm,dm,dmmc) values('06',		'01',	'房改购房');
insert into dk_sys_code(lxdm,dm,dmmc) values('06',		'02',	'危改购房');
insert into dk_sys_code(lxdm,dm,dmmc) values('06',		'03',	'购买安居房');
insert into dk_sys_code(lxdm,dm,dmmc) values('06',		'04',	'购买商品房');
insert into dk_sys_code(lxdm,dm,dmmc) values('06',		'05',	'购买他人私房');
insert into dk_sys_code(lxdm,dm,dmmc) values('06',		'06',	'期房');
insert into dk_sys_code(lxdm,dm,dmmc) values('06',		'07',	'现房');
insert into dk_sys_code(lxdm,dm,dmmc) values('06',		'08',	'多层');
insert into dk_sys_code(lxdm,dm,dmmc) values('06',		'09',	'高层');

insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'01',	'借款人身份证');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'02',	'借款人申请书');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'03',	'借款人户口簿');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'04',	'南京市商品房买卖契约');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'05',	'结婚证');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'06',	'建行公积金缴存证明');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'07',	'证明函');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'08',	'首付款的收据');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'09',	'审批通知书');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'10',	'未婚证明');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'11',	'离婚判决书');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'12',	'丧偶证明');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'13',	'处级职称证明');
insert into dk_sys_code(lxdm,dm,dmmc) values('07',		'14',	'高级职称证明');

--单个图档状态列表
insert into dk_sys_code(lxdm,dm,dmmc) values('08',		'01',	'未注册');
insert into dk_sys_code(lxdm,dm,dmmc) values('08',		'02',	'已注册未上传');
insert into dk_sys_code(lxdm,dm,dmmc) values('08',		'03',	'已上传');
insert into dk_sys_code(lxdm,dm,dmmc) values('08',		'04',	'已备份未删除');
insert into dk_sys_code(lxdm,dm,dmmc) values('08',		'05',	'已备份已删除');

insert into dk_sys_code(lxdm,dm,dmmc) values('09',		'00',	'中心');
insert into dk_sys_code(lxdm,dm,dmmc) values('09',		'01',	'建行三元巷受理处');
insert into dk_sys_code(lxdm,dm,dmmc) values('09',		'02',	'建行北京西路');
insert into dk_sys_code(lxdm,dm,dmmc) values('09',		'03',	'工行中山东路');

insert into dk_sys_code(lxdm,dm,dmmc) values('10',		'01',	'商品房');
insert into dk_sys_code(lxdm,dm,dmmc) values('10',		'02',	'二手房');

insert into dk_sys_code(lxdm,dm,dmmc) values('11',		'01',	'未婚');
insert into dk_sys_code(lxdm,dm,dmmc) values('11',		'02',	'已婚');
insert into dk_sys_code(lxdm,dm,dmmc) values('11',		'03',	'离婚');
insert into dk_sys_code(lxdm,dm,dmmc) values('11',		'04',	'丧偶');

--个人图档状态列表
insert into dk_sys_code(lxdm,dm,dmmc) values('12',		'01',	'未注册');
insert into dk_sys_code(lxdm,dm,dmmc) values('12',		'02',	'未注册全');
insert into dk_sys_code(lxdm,dm,dmmc) values('12',		'03',	'注册全未上传');
insert into dk_sys_code(lxdm,dm,dmmc) values('12',		'04',	'未上传全');
insert into dk_sys_code(lxdm,dm,dmmc) values('12',		'05',	'上传全，等待审批');
insert into dk_sys_code(lxdm,dm,dmmc) values('12',		'06',	'通知书未注册');
insert into dk_sys_code(lxdm,dm,dmmc) values('12',		'07',	'通知书未上传');
insert into dk_sys_code(lxdm,dm,dmmc) values('12',		'08',	'通知书已上传');