Breaking News: Grepper is joining You.com. Read the official announcement!

Delete table in Oracle

Add Answer

Mahesh Kumar Yadav answered on January 23, 2021 Popularity 8/10 Helpfulness 1/10

answer Delete table in Oracle

related oracle sql drop table

related delete rows table oracle

related delete all table oracle

related Drop Table Oracle

Delete table in Oracle

Comment

DROP TABLE C##BOBSIE.FakeInnerContainers

Popularity 8/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: oracle sql

Link to this answer
Share Copy Link

Contributed on Mar 16 2023

Mahesh Kumar Yadav

0 Answers Avg Quality 2/10

Closely Related Answers

oracle sql drop table

Comment

DROP TABLE my_table;
-- To 'really' free space
DROP TABLE my_table PURGE;

Popularity 10/10 Helpfulness 8/10 Language sql

Source: Grepper

Tags: oracle or

Link to this answer
Share Copy Link

Contributed on Jan 23 2021

VasteMonde

0 Answers Avg Quality 2/10

delete rows table oracle

Comment

DELETE FROM my_table;		-- all rows, commit needed
TRUNCATE TABLE my_table;	-- all rows, no possible rollback
DELETE FROM my_table WHERE my_id = 12345;
DELETE FROM my_table WHERE my_id IN (SELECT id2 FROM my_table2);
COMMIT;		-- don't forget it...

Popularity 10/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: oracle or

Link to this answer
Share Copy Link

Contributed on May 15 2021

VasteMonde

0 Answers Avg Quality 2/10

delete all table oracle

Comment

BEGIN
   FOR cur_rec IN (SELECT object_name, object_type
                   FROM user_objects
                   WHERE object_type IN
                             ('TABLE',
                              'VIEW',
                              'MATERIALIZED VIEW',
                              'PACKAGE',
                              'PROCEDURE',
                              'FUNCTION',
                              'SEQUENCE',
                              'SYNONYM',
                              'PACKAGE BODY'
                             ))
   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;
   FOR cur_rec IN (SELECT * 
                   FROM all_synonyms 
                   WHERE table_owner IN (SELECT USER FROM dual))
   LOOP
      BEGIN
         EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM ' || cur_rec.synonym_name;
      END;
   END LOOP;
END;
/

Popularity 10/10 Helpfulness 6/10 Language sql

Source: stackoverflow.com

Tags: drop

Link to this answer
Share Copy Link

Contributed on Aug 10 2021

Sleepy Squirrel

0 Answers Avg Quality 2/10

Drop Table Oracle

Comment

DROP TABLE customers PURGE

Popularity 10/10 Helpfulness 2/10 Language sql

Source: www.javatpoint.com

Tags: drop-table d

Link to this answer
Share Copy Link

Contributed on Oct 20 2021

Different Dingo

0 Answers Avg Quality 2/10

Delete table in Oracle

Contents

More Related Answers

Delete table in Oracle

Closely Related Answers

oracle sql drop table

delete rows table oracle

delete all table oracle

Drop Table Oracle

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.