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 votes247 views2 answers
Add days in oracle sql
SQL
4 votes220 views3 answers
Sql drop primary key
SQL
9 votes209 views4 answers
How to remove duplicate in sql
SQL
4 votes248 views4 answers
Remove duplicate old value in mysql
SQL
0 vote211 views1 answer
How to check default value of column in sql server
SQL
0 vote250 views1 answer
Finding leap year in sql
SQL
0 vote203 views1 answer
Dasebase_url-postgres for windows
SQL
0 vote236 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
6 votes215 views5 answers
Alter table oracle
SQL
1 vote251 views1 answer
Nvl postgres
SQL