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

11 votes345 views3 answers
Change column name sql server management studio
SQL
1 vote342 views1 answer
Mysql decimal allow negative values?
SQL
1 vote321 views1 answer
Oracle db create new schema
SQL
0 vote372 views1 answer
Cube oracle
SQL
2 votes334 views3 answers
Oracle show column of table
SQL
0 vote322 views1 answer
Sql remove first character from string
SQL
0 vote325 views3 answers
Convert sql query to python pandas
SQL
3 votes362 views2 answers
Order by postgresql
SQL
0 vote332 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote340 views1 answer
Sql insert from excel
SQL