银行储蓄管理系统---Oracle数据库表数据---Bank_Oracle_Data.sql
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了银行储蓄管理系统---Oracle数据库表数据---Bank_Oracle_Data.sql,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含13968字,纯文字阅读大概需要20分钟。
内容图文
![银行储蓄管理系统---Oracle数据库表数据---Bank_Oracle_Data.sql](/upload/InfoBanner/zyjiaocheng/484/67f5c3405bda415794234deeb1f77393.jpg)
SQL Developer import
file
prompt Created on 2017年6月4日
by Johnny
set feedback
off
set define
off
prompt Disabling triggers for ACCOUNT...
alter table ACCOUNT disable
all triggers;
prompt Disabling triggers for CLOSING_INSURANCE...
alter table CLOSING_INSURANCE disable
all triggers;
prompt Disabling triggers for CREDIT...
alter table CREDIT disable
all triggers;
prompt Disabling triggers for DEL_ACCOUNT...
alter table DEL_ACCOUNT disable
all triggers;
prompt Disabling triggers for DEPOSIT...
alter table DEPOSIT disable
all triggers;
prompt Disabling triggers for DEPUTE...
alter table DEPUTE disable
all triggers;
prompt Disabling triggers for DRAW...
alter table DRAW disable
all triggers;
prompt Disabling triggers for INTEREST_RATE...
alter table INTEREST_RATE disable
all triggers;
prompt Disabling triggers for LOAN...
alter table LOAN disable
all triggers;
prompt Disabling triggers for LOST...
alter table LOST disable
all triggers;
prompt Disabling triggers for MANAGER...
alter table MANAGER disable
all triggers;
prompt Disabling triggers for RECORD_PAY_INSURANCE...
alter table RECORD_PAY_INSURANCE disable
all triggers;
prompt Disabling triggers for REPAYMENT...
alter table REPAYMENT disable
all triggers;
prompt Disabling triggers for TRANSFER...
alter table TRANSFER disable
all triggers;
prompt Disabling triggers for USERS...
alter table USERS disable
all triggers;
prompt Deleting USERS...
delete from USERS;
commit;
prompt Deleting TRANSFER...
delete from TRANSFER;
commit;
prompt Deleting REPAYMENT...
delete from REPAYMENT;
commit;
prompt Deleting RECORD_PAY_INSURANCE...
delete from RECORD_PAY_INSURANCE;
commit;
prompt Deleting MANAGER...
delete from MANAGER;
commit;
prompt Deleting LOST...
delete from LOST;
commit;
prompt Deleting LOAN...
delete from LOAN;
commit;
prompt Deleting INTEREST_RATE...
delete from INTEREST_RATE;
commit;
prompt Deleting DRAW...
delete from DRAW;
commit;
prompt Deleting DEPUTE...
delete from DEPUTE;
commit;
prompt Deleting DEPOSIT...
delete from DEPOSIT;
commit;
prompt Deleting DEL_ACCOUNT...
delete from DEL_ACCOUNT;
commit;
prompt Deleting CREDIT...
delete from CREDIT;
commit;
prompt Deleting CLOSING_INSURANCE...
delete from CLOSING_INSURANCE;
commit;
prompt Deleting ACCOUNT...
delete from ACCOUNT;
commit;
prompt Loading ACCOUNT...
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
8600000022,
‘123456‘, .
1, to_date(
‘01-06-2017 19:43:09‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
8600000025,
‘123456‘, .
1, to_date(
‘01-06-2017 21:34:41‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
1010000025,
‘0‘, .
1, to_date(
‘01-06-2017 23:50:11‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
1010031,
‘123456‘,
791054.05, to_date(
‘02-06-2017 13:10:10‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
0,
‘321‘);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
1010001,
‘123456‘, .
1, to_date(
‘04-06-2017 11:37:28‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘中国‘,
0,
0,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
8600000001,
‘0‘,
2000000, to_date(
‘01-01-2017‘,
‘dd-mm-yyyy‘),
‘sd‘,
1,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
1010028,
‘123456‘, .
1, to_date(
‘02-06-2017 13:00:48‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
1010029,
‘123456‘, .
1, to_date(
‘02-06-2017 13:01:06‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
8600000021,
‘123456‘, .
1, to_date(
‘01-06-2017 19:40:09‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
8600000024,
‘123456‘, .
1, to_date(
‘01-06-2017 20:14:48‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
8600000026,
‘123456‘, .
1, to_date(
‘01-06-2017 21:36:32‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘中国‘,
0,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
1010002,
‘123456‘, .
1, to_date(
‘02-06-2017 09:42:02‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
1010021,
‘123456‘, .
1, to_date(
‘02-06-2017 12:35:05‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
1010030,
‘123456‘,
4.1, to_date(
‘02-06-2017 13:03:05‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘中国‘,
0,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
1010041,
‘123456‘,
602000.1, to_date(
‘04-06-2017 11:36:39‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
0,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
1010023,
‘123456‘, .
1, to_date(
‘02-06-2017 12:43:02‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘中国‘,
0,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
123457,
‘123‘,
100, to_date(
‘01-01-2017‘,
‘dd-mm-yyyy‘),
‘sd‘,
1,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
8600000023,
‘123456‘, .
1, to_date(
‘01-06-2017 19:50:53‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
1010000027,
‘0‘, .
1, to_date(
‘02-06-2017 00:00:10‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘中国‘,
0,
3,
null);
insert into ACCOUNT (id, password, balance, opendate, openaddress, isdignity, islost, other)
values (
1010000026,
‘0‘,
6075467799.1, to_date(
‘01-06-2017 23:58:54‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘山东省‘,
1,
3,
null);
commit;
prompt 20 records loaded
prompt Loading CLOSING_INSURANCE...
prompt Table is empty
prompt Loading CREDIT...
insert into CREDIT (cardint, username, withid, balance, creditlimit, creditstatus, other)
values (
8180001,
‘123‘,
1010031,
-921,
50000,
‘良‘,
null);
commit;
prompt 1 records loaded
prompt Loading DEL_ACCOUNT...
insert into DEL_ACCOUNT (delid, id, balance_beforedel, deldate, operaterid)
values (
100,
123456,
100, to_date(
‘01-06-2017 21:48:03‘,
‘dd-mm-yyyy hh24:mi:ss‘),
123);
insert into DEL_ACCOUNT (delid, id, balance_beforedel, deldate, operaterid)
values (
101,
123456,
100, to_date(
‘01-06-2017 21:48:32‘,
‘dd-mm-yyyy hh24:mi:ss‘),
123);
insert into DEL_ACCOUNT (delid, id, balance_beforedel, deldate, operaterid)
values (
103,
123456,
100, to_date(
‘01-06-2017 21:55:03‘,
‘dd-mm-yyyy hh24:mi:ss‘),
123);
insert into DEL_ACCOUNT (delid, id, balance_beforedel, deldate, operaterid)
values (
102,
123456,
100, to_date(
‘01-06-2017 21:54:05‘,
‘dd-mm-yyyy hh24:mi:ss‘),
123);
commit;
prompt 4 records loaded
prompt Loading DEPOSIT...
insert into DEPOSIT (depositid, id, amount, depositdate, deposittype, interest, operaterid)
values (
8880022,
1010031,
323232, to_date(
‘02-06-2015 13:19:24‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘定期‘, .
005,
123);
insert into DEPOSIT (depositid, id, amount, depositdate, deposittype, interest, operaterid)
values (
8880025,
1010031,
3123132, to_date(
‘02-06-2017 17:26:01‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘定期‘, .
005,
123);
insert into DEPOSIT (depositid, id, amount, depositdate, deposittype, interest, operaterid)
values (
8880000001,
1010000026,
1231, to_date(
‘02-06-2017 00:14:47‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘活期‘, .
001,
123);
insert into DEPOSIT (depositid, id, amount, depositdate, deposittype, interest, operaterid)
values (
8880000021,
1010000026,
10000, to_date(
‘02-06-2017 08:58:54‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘活期‘, .
001,
123);
insert into DEPOSIT (depositid, id, amount, depositdate, deposittype, interest, operaterid)
values (
8880000022,
1010000026,
332211222, to_date(
‘02-06-2017 09:28:09‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘活期‘, .
001,
123);
insert into DEPOSIT (depositid, id, amount, depositdate, deposittype, interest, operaterid)
values (
8880000023,
1010000026,
221133113, to_date(
‘02-06-2017 09:29:55‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘活期‘, .
001,
123);
insert into DEPOSIT (depositid, id, amount, depositdate, deposittype, interest, operaterid)
values (
8880000024,
1010000026,
5522112233, to_date(
‘02-06-2017 09:30:39‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘活期‘, .
001,
123);
insert into DEPOSIT (depositid, id, amount, depositdate, deposittype, interest, operaterid)
values (
8880042,
1010031,
4, to_date(
‘04-06-2017 00:18:28‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘定期‘, .
005,
123);
insert into DEPOSIT (depositid, id, amount, depositdate, deposittype, interest, operaterid)
values (
8880063,
1010031,
1000, to_date(
‘04-06-2017 13:09:46‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘定期‘, .
005,
1000);
commit;
prompt 9 records loaded
prompt Loading DEPUTE...
prompt Table is empty
prompt Loading DRAW...
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000002,
1010031,
10000,
0,
10000, to_date(
‘02-06-2017 14:07:37‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘快捷取款‘,
123);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000006,
1010031,
213,
0,
213, to_date(
‘02-06-2017 17:36:18‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘快捷取款‘,
123);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000007,
1010031,
100,
0,
100, to_date(
‘02-06-2017 18:04:51‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘信用卡取款‘,
123);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000011,
1010031,
123,
0,
123, to_date(
‘02-06-2017 18:18:04‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘快捷取款‘,
123);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000047,
1010031,
1312,
0,
1312, to_date(
‘04-06-2017 11:15:54‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘快捷取款‘,
1000);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000052,
1010031,
123,
0,
123, to_date(
‘04-06-2017 11:32:43‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘快捷取款‘,
1000);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000053,
1010031,
10000,
0,
10000, to_date(
‘04-06-2017 13:16:51‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘存款单取款‘,
1000);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000000005,
123456,
100,
0,
100, to_date(
‘01-06-2017‘,
‘dd-mm-yyyy‘),
‘hq‘,
123);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000004,
1010031,
123123,
0,
123123, to_date(
‘02-06-2017 17:32:45‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘快捷取款‘,
123);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000022,
1010031,
321,
0,
321, to_date(
‘04-06-2017 00:20:23‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘信用卡取款‘,
123);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000041,
1010031,
323232,
0,
323232, to_date(
‘04-06-2017 10:59:38‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘存款单取款‘,
1000);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000045,
1010031,
1312,
0,
1312, to_date(
‘04-06-2017 11:09:05‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘快捷取款‘,
1000);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000050,
1010031,
32,
0,
32, to_date(
‘04-06-2017 11:25:03‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘快捷取款‘,
1000);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000008,
1010031,
123,
0,
123, to_date(
‘02-06-2017 18:05:14‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘快捷取款‘,
123);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000010,
1010031,
123,
0,
123, to_date(
‘02-06-2017 18:12:01‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘快捷取款‘,
123);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000043,
1010031,
123,
0,
123, to_date(
‘04-06-2017 11:03:59‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘存款单取款‘,
1000);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000049,
1010002,
1111,
0,
1111, to_date(
‘04-06-2017 11:24:10‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘存款单取款‘,
1000);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000005,
1010031,
123123,
0,
123123, to_date(
‘02-06-2017 17:32:59‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘快捷取款‘,
123);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000044,
1010031,
54234523,
0,
54234523, to_date(
‘04-06-2017 11:07:45‘,
‘dd-mm-yyyy hh24:mi:ss‘),
‘存款单取款‘,
1000);
insert into DRAW (drawid, id, amount, interest, balance, drawdate, drawtype, operaterid)
values (
1000051,
1010031,
123123,
0,
123123, to_date(
‘04-06-2017 11:26:59‘,
‘dd-mm-yyyy hh24:mi:ss
本文系统来源:http://www.cnblogs.com/yixianyong/p/6940542.html
内容总结
以上是互联网集市为您收集整理的银行储蓄管理系统---Oracle数据库表数据---Bank_Oracle_Data.sql全部内容,希望文章能够帮你解决银行储蓄管理系统---Oracle数据库表数据---Bank_Oracle_Data.sql所遇到的程序开发问题。
如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
来源:【匿名】