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 vote139 views1 answer
Use of now() in mysql
SQL
0 vote193 views1 answer
Get enginge db mysql
SQL
1 vote166 views1 answer
Sample in sql
SQL
4 votes159 views1 answer
Mysql ip address data type
SQL
0 vote143 views1 answer
Automate mysql cli query
SQL
0 vote156 views1 answer
Every Derived yable must have its own alias
SQL
4 votes159 views1 answer
Group by mysql and concatenate string
SQL
0 vote179 views1 answer
Mysql select row with min date
SQL
1 vote150 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
57 votes1.4K views5 answers
How to create a new user in postgresql
SQL