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 vote234 views1 answer
Create table using the clause with as
SQL
0 vote182 views1 answer
Mysql auto increment default value with prefix month and year
SQL
2 votes190 views1 answer
How to make insert script from table in SQL server
SQL
0 vote197 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
11 votes193 views1 answer
Sql query to find duplicates in column
SQL
0 vote193 views1 answer
How to install sql in anaconda
SQL
0 vote185 views1 answer
Select all same column value in sql
SQL
0 vote203 views1 answer
Ver usuarios mysql
SQL
0 vote186 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote190 views1 answer
Selecting Data in SQL - Select Data
SQL