Using LOWER and UPPER

- [Instructor] Using the lower and upper…string functions in Oracle allows us to control…the case of data that is presented by our SQL query.…So for example, let's start by selecting the first name,…and last name of employees…in the employees table,…without a filter.…As we can see, the data was entered…using a combination of upper case and lower case characters.…We can capitalize all letters of the first name…by typing upper and placing the column name inside brackets.…

We can also make sure that all letters…in the last name column will be presented…as lower case by typing lower.…Running this query again will show us that we got…a fully capitalized first name,…and a last name that's all in lower case characters.…This is also especially useful…when we want to filter based on string values.…For example, let us say that we want to return…all the employees who's first name are David.…

So if we'll just type select, first name.…Let's delete the upper function for now.…Last name, and delete the lower function for now,…