Answers for "oracle drop type if exists"

oracle drop type if exists

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;

Posted by: Guest on August-07-2021

Code answers related to "oracle drop type if exists"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "oracle drop type if exists"

Code answers related to "oracle drop type if exists"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "oracle drop type if exists"

Code answers related to "oracle drop type if exists"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us