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 vote264 views1 answer
Sql count matching group by
SQL
0 vote196 views1 answer
Check if record exists mysql
SQL
0 vote259 views2 answers
How to type a blank discord messgae
SQL
0 vote256 views2 answers
Soql last year
SQL
0 vote210 views1 answer
Insert using condition postgres
SQL
0 vote195 views1 answer
Shrink database file in sql server
SQL
1 vote270 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote198 views1 answer
Enable full text search mysql
SQL
0 vote201 views1 answer
Laravel eloquent get generated sql
SQL
0 vote167 views0 answer
SQL