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

17 votes133 views6 answers
Current date in sql
SQL
0 vote136 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
7 votes135 views2 answers
Create index mysql
SQL
0 vote143 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote127 views1 answer
Mariadb number format
SQL
0 vote130 views2 answers
Search stored procedures
SQL
4 votes163 views5 answers
Get last query in codeigniter 4
SQL
1 vote128 views1 answer
Mysql query where in select
SQL
7 votes129 views6 answers
Nth highest salary in sql
SQL
0 vote159 views1 answer
Inner join distinct
SQL