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

9 votes126 views3 answers
Sequence postgresql
SQL
-1 vote115 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote106 views1 answer
Oracle list subpartitions
SQL
5 votes101 views1 answer
Sql select ciunt
SQL
0 vote105 views1 answer
Copy Table from SQL to CSV
SQL
0 vote114 views1 answer
What is mysql_pconnect
SQL
2 votes138 views1 answer
Find column in all stored procedures sql server
SQL
2 votes121 views1 answer
Mariadb json select
SQL
0 vote115 views1 answer
Check database restore status sql script
SQL
0 vote100 views1 answer
Sqlite3 not commit
SQL