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

24 votes127 views6 answers
Sql change table name
SQL
0 vote139 views1 answer
Soql last week
SQL
0 vote131 views1 answer
Porcentaje sql
SQL
11 votes155 views2 answers
Set default column value sql
SQL
0 vote118 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote127 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
2 votes132 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote124 views3 answers
Mysql delete if not in another table
SQL
0 vote135 views2 answers
Get item by composite primary key mysql
SQL
0 vote88 views2 answers
Spring properties file for db
SQL