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

1 vote283 views1 answer
Psql view enum values
SQL
2 votes269 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote236 views1 answer
Lister les index d'une table oracle
SQL
2 votes256 views1 answer
Oracle trace file
SQL
3 votes250 views1 answer
Oracle user quota on tablespace
SQL
4 votes212 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote253 views1 answer
How to find the most occuring in SQL
SQL
0 vote230 views1 answer
Duplicate foreign key constraint name
SQL
0 vote315 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote342 views1 answer
Delet all record statment sql
SQL