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 vote114 views2 answers
Full join sql
SQL
0 vote114 views1 answer
How to login to mysql in homestead
SQL
0 vote114 views1 answer
Delete data from database sqlite android
SQL
0 vote125 views1 answer
Sqlite update where exists
SQL
0 vote137 views1 answer
Query for backup a database at another location in file system
SQL
1 vote123 views2 answers
Find a column in all tables mysql
SQL
0 vote123 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
1 vote115 views1 answer
Mysql column start with string
SQL
6 votes119 views5 answers
Sql add months to date
SQL
0 vote116 views1 answer
Get create sql of hibernqte entity
SQL