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 vote303 views1 answer
Mysql query problems and solutions
SQL
0 vote352 views1 answer
How to compile a function in oracle
SQL
-1 vote315 views1 answer
Spring boot mysql connection properties
SQL
0 vote293 views1 answer
Mysql installer no packages found
SQL
1 vote335 views1 answer
Psql view enum values
SQL
5 votes302 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote353 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote305 views1 answer
Rename view mysql
SQL
0 vote301 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote290 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL