This tutorial provides you all Oracle string functions with examples that help you manipulate character strings more effectively.

The Oracle INSTR () function searches for a substring in a string and returns the position of the substring in a string.

This tutorial shows you how to use the Oracle SUBSTR () function to extract a substring from a string in the database.

This tutorial shows you how to use the Oracle LENGTH () function to get the number of characters (or length) of a specified string.

May 5, 2025 · Summary: In this tutorial, you’ll learn how to use the Oracle TO_DATE() function to convert a date string to a value of the DATE type using a specific format.

This tutorial demonstrates how to utilize the Oracle CONCAT () function to concatenate two strings into a single string.

This tutorial shows you how to use the Oracle REPLACE () function to replace all occurrences of a substring in a string with another.

This tutorial shows you how to use the Oracle INITCAP () function to convert a string to proper case.

This tutorial shows you how to use the Oracle TRIM () function to remove unwanted characters from the leading, trailing, or both of a string.

This tutorial shows you how to use the Oracle TRANSLATE () function to perform single-character, one-to-one substitutions in one operation.