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

This Oracle tutorial explains how to use the Oracle / PLSQL SUBSTR function with syntax and examples. The Oracle / PLSQL SUBSTR functions allows you to extract a substring from a string.

The SUBSTR functions return a portion of char, beginning at character position, substring_length characters long. SUBSTR calculates lengths using characters as defined by the input character set.

Aug 6, 2024 · The SUBSTR functions returns the specified number (substring_length) of characters from a particular position of a given string. It has several variants, including SUBSTRB, SUBSTRC, …

In this tutorial we will learn how to use SUBSTR function with practicle examples.

May 28, 2025 · In this tutorial, you will learn how to use SUBSTR function in Oracle SQL to get a substring from a string.

May 17, 2025 · This comprehensive guide walks through beginner, intermediate, and advanced patterns for Oracle SUBSTR in real-world PL/SQL projects, including tips for performance optimization, error …

Dec 8, 2024 · The SUBSTR function is used to extract a substring from a given string. It returns a portion of the string starting at a specified position for a specified length.

Jul 31, 2021 · In Oracle, the SUBSTR() function returns a substring from a given string. SUBSTR() requires at least two arguments; the string, and the position for which to extract the substring from.

If you need to extract a substring from the beginning of a string, you can use the SUBSTR function with a negative value for the start_position parameter. For example, to extract the first 3 characters from …