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

2 votes228 views1 answer
While loop sql
SQL
0 vote229 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote230 views1 answer
Oracle create job if not exists
SQL
1 vote209 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote231 views1 answer
How to use select union and loop
SQL
15 votes238 views4 answers
Mysql where value is null
SQL
2 votes251 views1 answer
Ifnull postgres
SQL
0 vote232 views1 answer
Php get closest location by latitude longitude
SQL
0 vote229 views1 answer
Guid string to binary better
SQL
0 vote233 views1 answer
How to select an index in oracle sql
SQL