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

17 votes335 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote294 views1 answer
Postgresql auto increment not working
SQL
16 votes275 views2 answers
Oracle ddl
SQL
0 vote264 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
22 votes272 views3 answers
Join three tables sql
SQL
0 vote293 views1 answer
QCompleter con sql
SQL
2 votes273 views1 answer
Import large .sql files into lampp
SQL
7 votes274 views3 answers
Restore postgres database from sql file
SQL
0 vote298 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote270 views2 answers
Check mysql timezone
SQL