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 vote254 views1 answer
Default value false mysql
SQL
0 vote255 views1 answer
Sql revert migration
SQL
0 vote278 views1 answer
Insert or update sql query
SQL
20 votes293 views1 answer
Get all table name in sql through php
SQL
4 votes276 views1 answer
Conda install sqlalchemy
SQL
0 vote334 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote272 views1 answer
Exectuer myssql .sql
SQL
0 vote272 views1 answer
Sql get month from date
SQL
1 vote283 views1 answer
Oracle sequence last_number
SQL
25 votes270 views6 answers
Change column name mysql
SQL