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 vote346 views1 answer
Implizite joins sql
SQL
0 vote361 views1 answer
Find and replace database table phpmyadmin
SQL
5 votes380 views2 answers
Sql server port number
SQL
4 votes339 views1 answer
SQL order random
SQL
0 vote382 views1 answer
Stored procedures example
SQL
2 votes418 views1 answer
Mysql shell insert into
SQL
1 vote359 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote342 views1 answer
How to connect to mysql in ef 6
SQL
18 votes307 views2 answers
How to get all the tables displayed in oracle
SQL
1 vote376 views1 answer
Postgres check blocking
SQL