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

5 votes185 views1 answer
AND OR NOT operators sql
SQL
10 votes158 views4 answers
Join with multiple conditions sql
SQL
4 votes169 views3 answers
Postgres set default value
SQL
7 votes167 views2 answers
Mysql db size
SQL
-1 vote202 views2 answers
Sql search all tables for attributes
SQL
1 vote176 views2 answers
Sql insert timestamp
SQL
8 votes241 views1 answer
Oracle search code in packages
SQL
0 vote161 views1 answer
How to start my sql server on mac
SQL
1 vote157 views1 answer
Mysql check string don't have number
SQL
0 vote120 views1 answer
Bigquery information_schema schema all columns
SQL