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

1 vote214 views1 answer
Mysql show attributes of a table
SQL
0 vote210 views1 answer
On sql table data exists
SQL
3 votes224 views1 answer
Create a table with an id in mysql
SQL
0 vote209 views1 answer
Create query in where clasue
SQL
0 vote217 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote196 views1 answer
Get db connection detail from sql developer profile
SQL
20 votes197 views4 answers
Reset auto increment in MySQL
SQL
0 vote208 views1 answer
Output table plsql
SQL
1 vote276 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote226 views1 answer
Mysql reset wp_options
SQL