银行储蓄管理系统---Oracle数据库表数据---Bank_Oracle_Data.sql
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