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

3 votes324 views2 answers
To_char oracle
SQL
0 vote316 views1 answer
Mysql jdbc timezone
SQL
1 vote324 views1 answer
Mysql select if empty result
SQL
0 vote318 views1 answer
How to use query in nosql
SQL
0 vote362 views1 answer
Doesn't have default value mysql
SQL
0 vote358 views1 answer
Bitmap join index
SQL
0 vote334 views1 answer
Sql last time database was accessed
SQL
1 vote320 views2 answers
Create a unqie constraint mysql
SQL
13 votes306 views3 answers
Sql online code
SQL
0 vote342 views1 answer
Uncheck constraints and delete from table
SQL