LOWER(char) → 全部轉小寫UPPER(char) → 全部轉大寫INITCAP(char) → 首字大寫 (補充)-- 找出 delivery 方式為 classroom (不分大小寫)
SELECT * FROM courses
WHERE LOWER(education_delivery_method) = 'classroom';
效能提示:`LOWER(col) = 'value'` 會導致**全表掃描** (Function-Based Index 除外)。大表請建立 **函數索引**:
CREATE INDEX idx_courses_delivery_ci ON courses (LOWER(education_delivery_method));
-- 全大寫
SELECT UPPER(firstname) AS firstname, lastname FROM students WHERE ROWNUM < 11;
-- 首字大寫、其餘小寫 (如姓名顯示)
SELECT UPPER(SUBSTR(lastname,1,1)) || LOWER(SUBSTR(lastname,2,29)) AS formatted_name
FROM students WHERE ROWNUM < 11;
UPDATE students
SET lastname = UPPER(lastname)
WHERE lastname = 'Jones';
COMMIT;
-- 去除前後空白、統一大寫、替換特殊字元
UPDATE addr_table
SET city = UPPER(TRIM(REPLACE(city, '.', '')))
WHERE city IS NOT NULL;
`LOWER/UPPER` 是字串處理基石,善用於**不分大小寫查詢 (配合函數索引)、報表格式化、資料清洗標準化**。記住:查詢端加函數 = 索引失效,寫入端統一格式 = 查詢端免函數,架構層面解決大小寫問題最划算。