O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding String functions

Our first examples of functions will examine many of the single-row functions that are capable of transforming string, or character, data. Of course, string data is one of the most common types of data stored in a database, so our ability to transform such data through the use of functions is critical. The types of string functions at our disposal include case conversion functions and string manipulation functions.

Using case conversion functions

Case conversion functions involve the transformation of strings from one case to another. These types of functions are extremely common, particularly in reporting. They include:

  • UPPER()
  • LOWER()
  • INITCAP()

UPPER()

Our first case conversion function is UPPER(), which is used to convert ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required