This tutorial provides you the most commonly used Oracle string functions that help you manipulate character strings more effectively.

The INSTR () function returns a positive integer that is the position of a substring within a string. If the string does not contain the substring, the INSTR () function returns 0 (zero).

This tutorial shows you how to use Oracle SUBSTR () function to extract a substring from a string and gives you examples of using the function effectively.

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

The Oracle LENGTH() function returns the number of characters of a specified string. It measures the length of the string in characters as defined by the input character set.

In this tutorial, you have learned how to use the Oracle CONCAT() function to concatenate two strings. You also learned how to use the concatenation operator (||) that concatenates three or …

Feb 29, 2016 · This page provides you with the most commonly used Oracle date functions that help you handle date and time data easily and more effectively.

The Oracle TRANSLATE() function returns a string with all occurrences of each character in a string replaced by its corresponding character in another string. The TRANSLATE() function …

The REGEXP_INSTR() function evaluates the string based on the pattern and returns an integer indicating the beginning or ending position of the matched substring, depending on the value …

In this tutorial, you will learn how to use the Oracle SOUNDEX () function to return a string that contains the phonetic representation of a string.