SQL: Lower() case manipulation function

This is also character function.
Used to Convert all alphabets into small letters.

Example:

Select Lower('HELLO World') from dual;

Result:

hello world.



We can use case manipulation functions when inserting  data into tables. Here to check we, First we create a table with name of example, then apply lower() case parameter.

Query:

Create table example(name varchar2(10));

Result:
table created.

Now insert data into example.

insert into example values(lower('TALHA'));

Result:

One Row inserted.

Now check by retrieve data.

Query:

Select * from example;

Result:

talha