Answers for "query to drop user in oracle"

SQL
1

oracle drop user

-- Specify CASCADE to drop all objects in the user's schema before dropping user.
DROP USER MY_USER CASCADE;
Posted by: Guest on March-23-2021
3

oracle drop all user views

BEGIN
    FOR cur_rec IN (SELECT OBJECT_NAME, OBJECT_TYPE
                    FROM ALL_OBJECTS		-- Choose types
                    WHERE OBJECT_TYPE IN ('TABLE', 'VIEW', 'PACKAGE',
                                          'PROCEDURE', 'FUNCTION', 'SEQUENCE'))
                          AND OWNER = 'owner_name'
        LOOP
            BEGIN
                IF cur_rec.OBJECT_TYPE = 'TABLE'
                THEN
                    EXECUTE IMMEDIATE 'DROP ' || cur_rec.OBJECT_TYPE || ' "'
                        || cur_rec.OBJECT_NAME || '" CASCADE CONSTRAINTS';
                ELSE
                    EXECUTE IMMEDIATE 'DROP ' || cur_rec.OBJECT_TYPE || ' "'
                        || cur_rec.OBJECT_NAME || '"';
                END IF;
            EXCEPTION
                WHEN OTHERS
                    THEN
                        DBMS_OUTPUT.PUT_LINE('FAILED: DROP '
                            || cur_rec.OBJECT_TYPE || ' "'
                            || cur_rec.OBJECT_NAME || '"');
            END;
        END LOOP;
END;
Posted by: Guest on July-10-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language