What you’ll learn in this Chapter
✓ List of all Single row character functions
✓ How to use functions in SELECT query
✓ SQL functions features and examples
Overview
All programming and scripting languages like C, Java, Python and others provides functions to ease some of the programming task. Similarly, Oracle provides several in-built functions to make data access simpler and development easier.
This chapter provides you the most commonly used Oracle string functions that help you manipulate character strings more effectively.