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

6 votes312 views2 answers
Can't connect to local mysql server through socket
SQL
1 vote338 views1 answer
Oracle apex version view
SQL
0 vote319 views1 answer
A network or instance-specific error sql server
SQL
1 vote320 views2 answers
Mysql insert generate serie
SQL
0 vote345 views1 answer
Sql gather statistics to increase performance
SQL
2 votes315 views1 answer
Mysql find tables with name
SQL
0 vote325 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote321 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote307 views1 answer
Version and edition of SQL Server Database Engine
SQL
5 votes306 views1 answer
How to check nls timestamp format in oracle
SQL