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

5 votes278 views2 answers
Mysql drop table cascade
SQL
11 votes258 views1 answer
Reset identity sql server
SQL
8 votes319 views2 answers
Between operator
SQL
0 vote281 views1 answer
How to get initials in sql
SQL
0 vote278 views1 answer
Hibernate with springboot mysql
SQL
7 votes295 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote299 views1 answer
Mysql insert into select transaction c#
SQL
8 votes277 views1 answer
Mac restore mysql database command line
SQL
11 votes269 views2 answers
Having keyword sql
SQL
13 votes283 views6 answers
Current date sql
SQL