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 vote215 views1 answer
.sql File Run in PSQL
SQL
1 vote218 views1 answer
How not to sort by average rating
SQL
0 vote192 views4 answers
Mysql on kubernetes
SQL
1 vote185 views1 answer
Group_concat max length mysql
SQL
0 vote195 views1 answer
Get the previous column of a table in mysql
SQL
0 vote181 views1 answer
Zerar auto increment mysql
SQL
0 vote206 views1 answer
Php select data from mysql database without column name
SQL
0 vote186 views1 answer
Mysql cli output to a file
SQL
13 votes231 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote237 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL