Show Me Glossary
 

Using Character Functions

Previous previous|next Next Page

Sheila needs to add more functionality to her reports. Her employee report needs to display the first name, separated by a space, followed by the last name, all in proper case. In addition, she needs the email data to display in lower case followed by "@oracle.com".

She has looked up the syntax for functions are created a small sheet on them:

Launch Demonstration

Show Me and Try It! - Use SQL Workshop to display the employee names separated with a space and in proper case

Launch Demonstration

Show Me and Try It! - Use Query Builder to display the email addresses in lower case with "@oracle.com" appended to the end of the email Id