Case-Manipulation Functions These functions convert case for character strings: Function Result LOWER('SQL Course') sql course UPPER('SQL Course') SQL COURSE INITCAP('SQL Course') Sql Course Copyright © 2004, Oracle. All rights reserved. Case-Manipulation Functions LOWER, UPPER, and INITCAP are the three case-conversion functions. LOWER: Converts mixed-case or uppercase character strings to lowercase • UPPER: Converts mixed-case or lowercase character strings to uppercase • INITCAP: Converts the first letter of each word to uppercase and remaining letters to • lowercase SELECT 'The job id for '||UPPER(last_name)||' is ' ||LOWER(job_id) AS "EMPLOYEE DETAILS" FROM employees; … Oracle Database 10g: SQL Fundamentals I 3-9
Case-Manipulation Functions These functions convert case for character strings: Result Function sql course LOWER('SQL Course') SQL COURSE UPPER('SQL Course') Sql Course INITCAP('SQL Course') Copyright © 2004, Oracle. All rights reserved. Case-Manipulation Functions LOWER, UPPER, and INITCAP are the three case-conversion functions. • LOWER: Converts mixed-case or uppercase character strings to lowercase • UPPER: Converts mixed-case or lowercase character strings to uppercase • INITCAP: Converts the first letter of each word to uppercase and remaining letters to lowercase SELECT 'The job id for '||UPPER(last_name)||' is ' ||LOWER(job_id) AS "EMPLOYEE DETAILS" FROM employees; … Oracle Database 10g: SQL Fundamentals I 3-9