The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to
12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain
references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Basic Delete Statements

Delete All Rows

DELETE <table_name>
or
DELETE FROM <table_name>;

conn uwclass/uwclass@pdbdev

CREATE TABLE t AS
SELECT *
FROM all_tables;

SELECT COUNT(*)
FROM t;

DELETE FROM t;

COMMIT;

SELECT COUNT(*)
FROM t;

Delete Selective Rows

DELETE FROM <table_name>
WHERE <filter_condition>;

conn uwclass/uwclass@pdbdev

CREATE TABLE t AS
SELECT *
FROM all_tables;

SELECT COUNT(*)
FROM t;

DELETE FROM tWHERE table_name LIKE '%MAP';

COMMIT;

SELECT COUNT(*)
FROM t;

Delete From A SELECT Statement: May be Selective or Non-Selective Depending on whether the SELECT
statement contains a WHERE clause