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

0 vote197 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote143 views1 answer
Sql right characters
SQL
1 vote155 views4 answers
Fatal database postgres does not exist
SQL
0 vote166 views1 answer
Install sql server windows 10
SQL
3 votes143 views1 answer
Uppercase and lowercase in sql
SQL
1 vote121 views1 answer
Unique vs distinct sql
SQL
0 vote258 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote144 views1 answer
Oracle tablespace autoextend
SQL
8 votes111 views2 answers
Alter column name in mssql
SQL
3 votes166 views2 answers
Order by postgresql
SQL