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 vote110 views1 answer
Wordpress sql change site url
SQL
0 vote95 views1 answer
Oracle list of long running queries
SQL
12 votes121 views6 answers
Change mysql root password
SQL
16 votes100 views4 answers
Mysql import from sql file
SQL
0 vote102 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote96 views1 answer
Clone table structure mysql
SQL
1 vote105 views1 answer
Postgresql create table with timestamp
SQL
5 votes118 views4 answers
SQL Order of execution
SQL
0 vote118 views2 answers
Impala rename column name
SQL
0 vote105 views1 answer
Sql select random procentage from rows
SQL