在Oracle數(shù)據(jù)庫中,使用DELETE語句刪除數(shù)據(jù)時,需要指定一個WHERE子句來指定刪除的條件。WHERE子句中的條件可以根據(jù)需要進行復(fù)雜的邏輯運算和比較操作,以確保只刪除符合條件的數(shù)據(jù)。
以下是一些常見的DELETE條件選擇示例:
DELETE FROM employees WHERE age > 30;
DELETE FROM employees WHERE salary < 5000;
DELETE FROM employees WHERE department_id = 10;
DELETE FROM employees WHERE name = '張三';
DELETE FROM employees WHERE name LIKE '張%';
DELETE FROM employees WHERE salary > 5000 AND department_id = 20;
DELETE FROM employees WHERE name = '李四' OR department_id = 30;
請注意,在使用DELETE語句時,務(wù)必確保WHERE子句中的條件是正確的,以避免意外刪除重要數(shù)據(jù)。建議在刪除數(shù)據(jù)之前先執(zhí)行SELECT語句來驗證要刪除的數(shù)據(jù)是否符合預(yù)期。