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 vote185 views1 answer
Get first monday of month sql
SQL
12 votes152 views6 answers
Between in sql
SQL
1 vote138 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote163 views1 answer
How to subquey to do not load in live database in
SQL
0 vote137 views1 answer
Pl sql constraint user function
SQL
5 votes163 views1 answer
Oracle asynchronous query
SQL
4 votes91 views1 answer
Generate class from sql table c#
SQL
1 vote160 views2 answers
This month mysql where
SQL
18 votes142 views4 answers
Mysql current date between two dates
SQL
0 vote155 views1 answer
How to import pymysql through jupyter notebook for windows
SQL