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 vote351 views1 answer
Select amount weeks between two dates mysql
SQL
5 votes401 views1 answer
Mysql count lines
SQL
18 votes352 views6 answers
Laravel form validation
SQL
0 vote366 views1 answer
Sql server pivot rows to columns
SQL
6 votes320 views1 answer
Oracle trigger after connect
SQL
0 vote361 views1 answer
Flask sqlalchemy session delete
SQL
0 vote354 views1 answer
Update one column from another column in same table
SQL
2 votes341 views3 answers
Current month mysql query
SQL
1 vote355 views1 answer
Right outer vs left outer join
SQL
3 votes342 views1 answer
Select nextval from sequence sql
SQL