code_standard_tracking/scripts/deinstall.sql at master · hhudson/code_standard_tracking · GitHub

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
begin
    wwv_flow_api.create_or_remove_file(
        p_location => 'APPLICATION',
        p_name     => 'fs-sprite.png',
        p_mode     => 'REMOVE',
        p_type     => 'IMAGE');
end;
/

declare
    l_stmt varchar2(1000);
begin
    for c1 in ( select sj.job_name, ao.object_name
                from user_scheduler_jobs sj, sys.all_objects ao
                where sj.job_name = 'EBA_STDS_TEST_UPD_JOB'
                    and ao.object_name in ('DBMS_SCHEDULER', 'CLOUD_SCHEDULER')
                    and ao.object_type = 'PACKAGE'
                order by object_name desc ) loop
        l_stmt := '[begin '||sys.dbms_assert.enquote_name(c1.object_name, false)
            ||'.drop_job( name => '''||c1.job_name||'''); end;]';
        execute immediate l_stmt;
        return;
    end loop;
end;
/

drop type eba_stds_filter_col_tbl;
drop type eba_stds_filter_column_t;

drop table eba_stds_flex_page_map      cascade constraints;
drop table eba_stds_flex_registry      cascade constraints;
drop table eba_stds_flex_static_lovs   cascade constraints;
drop table eba_stds_standard_statuses  cascade constraints;
drop table eba_stds_standard_type_ref  cascade constraints;
drop table eba_stds_standard_app_ref   cascade constraints;
drop table eba_stds_standard_tests     cascade constraints;
drop table eba_stds_standards          cascade constraints;
drop table eba_stds_app_statuses       cascade constraints;
drop table eba_stds_applications       cascade constraints;
drop table eba_stds_types              cascade constraints;
drop table eba_stds_notes              cascade constraints;
drop table eba_stds_access_levels      cascade constraints;
drop table eba_stds_history            cascade constraints;
drop table eba_stds_tags               cascade constraints;
drop table eba_stds_tags_type_sum      cascade constraints;
drop table eba_stds_tags_sum           cascade constraints;
drop table eba_stds_notifications      cascade constraints;
drop table eba_stds_preferences        cascade constraints;
drop table eba_stds_error_lookup       cascade constraints;
drop table eba_stds_users              cascade constraints;
drop table eba_stds_tz_pref            cascade constraints;
drop table eba_stds_errors             cascade constraints;
drop table eba_stds_test_validations   cascade constraints;

drop sequence eba_stds_seq;

drop package  eba_stds_export;
drop package  eba_stds_flex_fw;
drop package  eba_stds_filter2_fw;
drop package  eba_stds_parser;
drop package  eba_stds;
drop package  eba_stds_fw;
drop package  eba_stds_security;
drop package  eba_stds_data;
drop package  assert;

-- select apex_string.format('drop view %0;',lower(view_name)) stmt
-- from user_views
-- where (lower(view_name) like '%ast%' ) or  (lower(view_name) like 'v_eba%' )
-- order by view_name

drop view v_ast_apex_accessibility_item_label;
drop view v_ast_apex_accessibility_page_title;
drop view v_ast_apex_accessibility_theme;
drop view v_ast_apex_app_auth;
drop view v_ast_apex_app_item_naming;
drop view v_ast_apex_html_escaping_cols;
drop view v_ast_apex_item_help;
drop view v_ast_apex_page_auth;
drop view v_ast_apex_page_help;
drop view v_ast_apex_page_item_naming;
drop view v_ast_db_plsql_1_commented_specs;
drop view v_ast_db_plsql_2_discouraged_code;
drop view v_ast_db_plsql_3_duplicate_statements;
drop view v_ast_db_plsql_4_identifier_naming;
drop view v_ast_db_plsql_5_unusued_identifiers;
drop view v_ast_db_plsql_all;
drop view v_eba_stds_application_test_pass_fail;
drop view v_eba_stds_standards;
drop view v_eba_stds_standard_tests;