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;oracle drop type
DROP TYPE schema_name.type_name;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
