oracle drop type if exists

Solutions on MaxInterview for oracle drop type if exists by the best coders in the world

Search
showing results for - "oracle drop type if exists"
Elisa
26 Jan 2017
1DECLARE
2    existing_type number;
3BEGIN
4    SELECT count(*) into existing_type
5    FROM ALL_TYPES
6    WHERE TYPE_NAME = 'type_name' AND OWNER = 'schema_name';
7    IF existing_type = 1 then
8        EXECUTE IMMEDIATE 'DROP TYPE schema_name.type_name';
9    END IF;
10END;
similar questions
pl sql drop triggeralter table add check constraint oracledrop all triggers oracleoracle drop rulespl sql trigger determine if insert or update or deleteoracle drop sequence if existsoracle drop sequence check if table exists oracleoracle drop default valuesql drop view if existsoracle drop constraintoracle drop typeoracle create program if no existsoracle drop columnoracle drop job if existsdrop table if exists oracleoracle sql drop sequencedelete column from table oracle pl sqloracle drop index if existssql drop procedure if existsdrop primary key oracleoracle drop packageoracle drop schema proceduresoracle drop temporary tableoracle sql drop column if existsoracle drop all schema tablesoracle drop chain
queries leading to this page
drop type in oracleoracle drop typehow to drop type in oracleoracle drop type if exists