银行储蓄管理系统---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