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 vote289 views1 answer
Uncheck constraints and delete from table
SQL
1 vote294 views1 answer
Sql server delete top 1000
SQL
0 vote285 views1 answer
Postgres list all stored procedures query
SQL
0 vote283 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote264 views1 answer
Ora 00001 error catch plsql
SQL
0 vote287 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote383 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
1 vote260 views6 answers
In sql
SQL
0 vote277 views1 answer
Sql select most frequent value in column
SQL
2 votes302 views2 answers
Mysql bidirectional composite primary key
SQL