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

Member

by adan , in category: MySQL , 10 months ago

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

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by addison , 10 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.

Related Threads:

How to set run time env variable in webpack?
How to run two oracle instances in oracle 10g?
How to run oracle stored procedure in php?
How to run stored procedure in oracle with loop?
How to run oracle .sql file using java?
How to run a procedure having cursor output in oracle?