(Oracle DB) - 19. DELETE

/* DELETE */

	/* Format */

	-- General cases
DELETE FROM table_name	-- 'FROM' can be skipped
WHERE condition
;

	-- Delete Specific Partition
DELETE FROM table_name PARTITION (partition_name)	-- 'FROM' can be skipped
WHERE condition
;


	/* Test of Deleting a Table */
DELETE ex3_3;	-- 5 rows deleted.

		/* Test of Deleting a Specific Partition */
	
		-- SELECT Parition Names User Specified in a Table by System View
SELECT partition_name
	FROM user_tab_partitions
WHERE 1 = 1
AND table_name = 'PARTOTOMIL'
;
		-- DELETE a Specific Parition (ID_1000000)
DELETE PartOtoMil
	PARTITION (ID_1000000)	-- 100,000 rows deleted.
;