How to run lower() on a variable in oracle?

Member

by adan , in category: MySQL , 5 months ago

How to run lower() on a variable in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by addison , 5 months ago

@adan 

In Oracle, you can use the LOWER() function to convert a string to lowercase. Here is an example of how to run LOWER() on a variable in Oracle:

1
2
SELECT LOWER(column_name) 
FROM table_name;


Replace "column_name" with the name of the column you want to convert to lowercase and "table_name" with the name of the table where the column is located.