-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathIGE_USER.sql
92 lines (90 loc) · 10.8 KB
/
IGE_USER.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
--PROMPT PL/SQL Developer Export Tables for user IGE@MTB_LITSUP
--PROMPT Created by slee5 on June 5, 2019
-- SET FEEDBACK off
-- SET DEFINE off
--PROMPT Disabling foreign key constraints for IGE_USER...
--alter table IGE_USER disable constraint IGE_USER_FK;
--PROMPT Truncating IGE_USER...
truncate table IGE_USER;
--PROMPT Loading IGE_USER...
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (37, 'tashour', 'Tawfik', 'Ashour', '[email protected]', '416-338-1905', 'TS - S - MUN', 'LOCKED', to_timestamp('01-06-2009 10:11:45', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (49, 'chau', 'Ron', 'Chau', '[email protected]', '416-338-3962', 'TS - S - MUN', 'ACTIVE', to_timestamp('29-09-2011 10:50:05', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (51, 'shodgins', 'Steve', 'Hodgins', '[email protected]', '416-338-3963', 'TS - S - MUN', 'ACTIVE', to_timestamp('29-09-2011 10:52:45', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (53, 'dchristo', 'Desmond', 'Christopher', '[email protected]', '416-392-1831', 'TS - S - MUN', 'ACTIVE', to_timestamp('29-09-2011 10:54:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (54, 'wtang', 'Waisan', 'Tang', '[email protected]', '416-392-3366', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('12-04-2016', 'dd-mm-yyyy'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (36, 'jthorne', 'Jennifer', 'Thorne', '[email protected]', '416-338-1300', 'TS - S - MUN', 'LOCKED', to_timestamp('01-06-2009 10:09:37', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (28, 'kmerrem', 'Karl', 'Merrem', '[email protected]', '416-397-9024', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('06-01-2009 14:06:12', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (26, 'tburridg', 'Travis', 'Burridge', '[email protected]', '416-392-9128', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('06-01-2009 10:18:30', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (27, 'sdale', 'Steve', 'Dale', '[email protected]', '416-392-8339', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('06-01-2009 11:41:07', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (29, 'lostoma', 'Loriano', 'Ostoma', '[email protected]', '416-392-2516', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('15-01-2009 09:59:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (31, 'tcorreia', 'Tony', 'Correia', '[email protected]', '416-397-7551', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('25-02-2009 08:00:28', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (38, 'lle', 'Loan', 'Le', '[email protected]', '416-338-5021', 'TS - S - MUN', 'LOCKED', to_timestamp('04-06-2009 09:04:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (39, 'lli3', 'David', 'Li', '[email protected]', '416-397-0000', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('02-09-2009 15:55:23', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (12, 'bhall1', 'Brian', 'Hall', '[email protected]', '416-338-5034', 'TS - S&M - MUN', 'ACTIVE', to_timestamp('19-12-2008 17:50:23', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (15, 'ldiaz', 'Lucy', 'Diaz', '[email protected]', '416-397-7672', 'TS - S&M - MUN', 'ACTIVE', to_timestamp('19-12-2008 17:54:04', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (17, 'dmorgan', 'Dave', 'Morgan', '[email protected]', '416-397-7552', 'IT - SDS - GCC', 'EXPIRED', to_timestamp('19-12-2008 17:56:04', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (19, 'kamin', 'Khairul', 'Amin', '[email protected]', '416-338-5042', 'IT - SDS - GCC', 'LOCKED', to_timestamp('19-12-2008 17:57:52', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (22, 'emachyni', 'Elizabeth', 'Machynia', '[email protected]', '416-338-5029', 'TS - S&M - MUN', 'ACTIVE', to_timestamp('19-12-2008 18:04:33', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (32, 'smortime', 'Stephen', 'Mortimer', '[email protected]', '416-397-7545', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('25-02-2009 08:01:54', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (10, 'bsevigny', 'Bob', 'Sevigny', '[email protected]', '416-392-8451', 'IT - SDS - GCC', 'LOCKED', to_timestamp('17-12-2008 11:14:06', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (41, 'swebb', 'Scott', 'Webb', '[email protected]', '416-392-2999', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('26-01-2010 13:53:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (43, 'rdembins', 'Ray', 'Dimbinski', '[email protected]', '416-395-7362', 'CLK-ERS-ELEC', 'ACTIVE', to_timestamp('26-01-2010 13:55:25', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (30, 'kporter', 'Kevin', 'Porter', '[email protected]', '416-392-9075', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('19-01-2009 09:30:43', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (47, 'mpawlows', 'Marta', 'Pawlowski', '[email protected]', '416-338-5025', 'TS - S - MUN', 'ACTIVE', to_timestamp('29-09-2011 10:48:47', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (34, 'jcapizza', 'Joe', 'Capizzano', '[email protected]', '416-392-2997', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('02-03-2009 08:49:25', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (52, 'hmarrow', 'Hisham', 'Marrow', '[email protected]', '416-338-3961', 'TS - S - MUN', 'ACTIVE', to_timestamp('29-09-2011 10:53:28', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (35, 'Loan Le', 'loan', 'le', '[email protected]', '416-338-5021', 'TS - S - MUN', 'EXPIRED', to_timestamp('01-06-2009 09:01:54', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (42, 'zmiddle', 'Zoe', 'Middleton', '[email protected]', '416-395-7322', 'CLK-ERS-ELEC', 'ACTIVE', to_timestamp('26-01-2010 13:54:47', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (44, 'jmeragli', 'John', 'Meraglia', '[email protected]', '416-395-1303', 'CLK-ERS-ELEC', 'ACTIVE', to_timestamp('26-01-2010 13:56:03', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (45, 'jhouse', 'John', 'House', '[email protected]', '416-392-8338', 'TS - S - MUN', 'ACTIVE', to_timestamp('10-02-2010 10:43:54', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (48, 'vkemelm', 'Valery', 'Kemelman', '[email protected]', '416-392-2509', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('01-09-2011', 'dd-mm-yyyy'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (8, 'zwang', 'Joy', 'Wang', '[email protected]', '416-392-4525', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('24-06-2008 14:00:52', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (7, 'sarzand', 'Sepideh', 'Arzandeh', '[email protected]', '416-397-7567', 'IT - SDS - GCC', 'ACTIVE', to_timestamp('24-06-2008 14:00:52', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (21, 'mminda', 'Maria', 'Minda', '[email protected]', '416-397-7558', 'IT - SDS - GCC', 'EXPIRED', to_timestamp('19-12-2008 18:03:43', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (14, 'jfligg', 'John', 'Fligg', '[email protected]', '416-338-5031', 'TS - S&M - MUN', 'ACTIVE', to_timestamp('19-12-2008 17:53:19', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (23, 'ilaw', 'Ian', 'Law', '[email protected]', '416-338-1302', 'IT - SDS - GCC', 'LOCKED', to_timestamp('19-12-2008 18:05:21', 'dd-mm-yyyy hh24:mi:ss'));
insert into IGE_USER (user_id, username, first_name, last_name, email, phone, business_unit, status, status_date)
values (25, 'vgomes', 'Virgil', 'Gomes', '[email protected]', '416-338-5033', 'IT - SDS - GCC', 'LOCKED', to_timestamp('19-12-2008 18:17:05', 'dd-mm-yyyy hh24:mi:ss'));
--commit;
--PROMPT 37 records loaded
--PROMPT Enabling foreign key constraints for IGE_USER...
--alter table IGE_USER enable constraint IGE_USER_FK;
-- SET FEEDBACK on
-- SET DEFINE on
--PROMPT Done