Oracle drop type

DECLARE
    existing_type number;
BEGIN
    SELECT count(*) into existing_type
    FROM ALL_TYPES
    WHERE TYPE_NAME = 'type_name' AND OWNER = 'schema_name';
    IF existing_type = 1 then
        EXECUTE IMMEDIATE 'DROP TYPE schema_name.type_name';
    END IF;
END;

Similar codes

13 votes209 views4 answers
Mysql remove foreign key constraint
SQL
11 votes170 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
14 votes145 views1 answer
Oracle alter table add column not null
SQL
0 vote135 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote150 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote148 views1 answer
Sql change column in existing table
SQL
10 votes213 views2 answers
Doublon sql
SQL
0 vote167 views2 answers
Suse Linux restart MySQL
SQL
0 vote164 views2 answers
While mysql
SQL
5 votes131 views2 answers
Add column postgres with default value
SQL