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 vote181 views1 answer
Mssql disable foreign key constraint
SQL
8 votes187 views1 answer
How to check mysql version in xampp
SQL
0 vote215 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote237 views1 answer
Mysql row generator
SQL
1 vote176 views1 answer
Oracle first row
SQL
0 vote189 views1 answer
Test database for sql
SQL
2 votes202 views5 answers
Tablespace ORACLE
SQL
1 vote223 views1 answer
Psql client write to bash variable
SQL
5 votes173 views2 answers
Sql number columns
SQL
0 vote190 views1 answer
Create database like
SQL