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

2 votes221 views1 answer
Sql percentage with % rounded down
SQL
0 vote191 views1 answer
Sql server 2012 create or alter procedure
SQL
1 vote253 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
1 vote195 views2 answers
Sql convert datetime to year month
SQL
2 votes195 views1 answer
Oracle apex list connected users
SQL
1 vote203 views1 answer
Query for all indexes in table postgres
SQL
1 vote198 views1 answer
Mysql view command
SQL
15 votes180 views7 answers
MYSQL
SQL
0 vote198 views2 answers
Oracle sql for each row
SQL
0 vote202 views1 answer
Comparing with today and yesterday record in sql query
SQL