oracle drop type

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

Search
showing results for - "oracle drop type"
Tatiana
06 Mar 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;
source
Brandi
10 Mar 2017
1DROP TYPE schema_name.type_name;
similar questions
oracle drop programdrop all triggers oracledrop colum oracle 18coracle drop rulesoracle drop jobdrop index oracleoracle drop sequence oracle drop default valueoracle drop constraintoracle drop columnoracle sql drop sequencedelete column from table oracle pl sqldrop primary key oracleoracle drop packageoracle drop userdelete oracleoracle drop schema proceduresoracle drop temporary tableoracle sql drop column if existsoracle drop all schema tablesoracle drop chainoracle drop partitionoracle sql drop table purgeoracle delete schema objectsoracle sql drop table
queries leading to this page
drop type in oracleoracle drop typehow to drop type in oracleoracle drop type