-
Notifications
You must be signed in to change notification settings - Fork 0
/
dmn_PLAN_STATUS.sql
23 lines (21 loc) · 1.53 KB
/
dmn_PLAN_STATUS.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
--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 Truncating DMN_PLAN_STATUS...
--prompt Truncating DMN_PLAN_STATUS...
truncate table DMN_PLAN_STATUS;
--prompt Loading DMN_PLAN_STATUS...
insert into DMN_PLAN_STATUS (plan_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('PREAPPROVAL', 'Pre-Approval', 1, to_timestamp('24-06-2008 14:00:12', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_PLAN_STATUS (plan_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('APPROVED', 'Approved', 2, to_timestamp('24-06-2008 14:00:12', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_PLAN_STATUS (plan_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('REGISTERED', 'Registered', 3, to_timestamp('24-06-2008 14:00:12', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
insert into DMN_PLAN_STATUS (plan_status, description, sort_sequence, date_effective, date_expiry, trans_id_create, trans_id_expire)
values ('DEEMED TO BE UNREGISTERED', 'Deemed to be unregistered', 4, to_timestamp('24-06-2008 14:00:12', 'dd-mm-yyyy hh24:mi:ss'), to_timestamp('01-01-3000', 'dd-mm-yyyy'), 1, -1);
--commit;
--prompt 4 records loaded
--set feedback on
--set define on
--prompt Done