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 vote300 views1 answer
Mysql select count if contains
SQL
0 vote294 views1 answer
Select last N rows mysql
SQL
2 votes308 views2 answers
Postgres drop column if exists
SQL
8 votes305 views1 answer
Oracle create datafile
SQL
0 vote306 views1 answer
How to add timestamp column in mysql
SQL
0 vote303 views1 answer
Normalization in database 2nd normal form
SQL
0 vote318 views1 answer
Nvl2 syntax
SQL
13 votes271 views3 answers
Uninstall mysql centos 7
SQL
0 vote304 views1 answer
How to update sql server version
SQL
0 vote287 views1 answer
Login failed for login due to trigger execution
SQL