Breaking News: Grepper is joining You.com. Read the official announcement!

upper and lower in oracle sql

Rasel Ahmed answered on June 14, 2022 Popularity 9/10 Helpfulness 7/10

answer upper and lower in oracle sql

upper and lower in oracle sql

Comment

LOWER: It shows the entire word in lower case.
UPPER: The string is converted to all-caps.
INITCAP: The first letter of each word capitalised, and all other letters in lower case.


SELECT LOWER('ENGLAND') AS LOWER_VAL FROM dual; -- output: england
SELECT UPPER('England') AS upper_val FROM dual; -- output: ENGLAND
SELECT INITCAP('Once upon a time...') AS testvalue FROM dual; -- output: Once Upon A Time…

Popularity 9/10 Helpfulness 7/10 Language sql

Source: www.databasestar.com

Tags: oracle sql

Link to this answer
Share Copy Link