length & substr

Oracle中SUBSTR函数详解

最新推荐文章于 2022-05-28 13:48:59 发布

最新推荐文章于 2022-05-28 13:48:59 发布 · 159 阅读

文章标签：

#length &amp; substr #java #工作

java 同时被 2 个专栏收录

28 篇文章

订阅专栏

length & substr

0 篇文章

订阅专栏

本文深入探讨了Oracle PLSQL中SUBSTR函数的使用方法，包括其语法、参数及实例应用，帮助读者掌握如何从字符串中提取子串。

oracle中substr函数的用法

In oracle/PLSQL, the substr functions allows you to extract a substring from a string.

The syntax for the substr function is:

substr( string, start_position, [ length ] )
说明：
string is the source string.
start_position is the position for extraction. The first position in the string is always 1.
length is optional. It is the number of characters to extract. If this parameter is omitted, substr will return the entire string.
For example:
substr('This is a test', 6, 2) would return 'is'
substr('This is a test', 6) would return 'is a test'
substr('TechOnTheNet', 1, 4) would return 'Tech'
substr('TechOnTheNet', -3, 3) would return 'Net'
substr('TechOnTheNet', -6, 3) would return 'The'
substr('TechOnTheNet', -8, 2) would return 'On'