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

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.

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.

I would like to be able to write a query that selects this column from said table, but only returns the substring up to the Underscore (_) character. For example:

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

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, …

Dec 8, 2024 · In SQL, both the SUBSTR (or SUBSTRING in some databases) and INSTR functions are used to work with strings, but they serve different purposes. Here's a breakdown of each function …

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

In this article, we will learn how to set up an Oracle instance, create sample data and understand the use of the substring function.

This page describes the use of the Oracle character function SUBSTR which replaces the left and right statements from other SQL dialects.