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 vote169 views1 answer
Oracle sql date summer time
SQL
4 votes198 views2 answers
Dbms output
SQL
0 vote179 views1 answer
Oracle current session details
SQL
1 vote180 views1 answer
Alter constraint postgres
SQL
1 vote172 views4 answers
Fatal database postgres does not exist
SQL
11 votes198 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote245 views1 answer
Oracle convert int to date
SQL
0 vote186 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
3 votes219 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
19 votes182 views4 answers
Rename database in sql
SQL