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

8 votes153 views4 answers
Reset SQL auto increment
SQL
1 vote117 views1 answer
Sql server reseed single table
SQL
0 vote169 views1 answer
Kimball data warehouse sql calendar
SQL
1 vote203 views1 answer
Oracle create program if not exists
SQL
0 vote139 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote129 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
14 votes129 views4 answers
Sql compiler
SQL
13 votes128 views4 answers
Mysql select last 10 rows
SQL
0 vote138 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
1 vote129 views1 answer
Sql drop with dependencies
SQL