oracle中substr函数的用法
来源:互联网 发布:淘宝摄影服务 编辑:程序博客网 时间:2024/04/27 13:41
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:
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) wouldreturn 'is a test'
substr('TechOnTheNet', 1, 4) wouldreturn 'Tech'
substr('TechOnTheNet',-3, 3) wouldreturn 'Net'
substr('TechOnTheNet',-6, 3) wouldreturn 'The'
substr('TechOnTheNet',-8, 2) wouldreturn 'On'
- oracle中substr函数的用法
- oracle中substr函数的用法
- oracle中substr函数的用法
- oracle中substr函数的用法
- oracle中substr函数的用法
- oracle中substr函数的用法
- oracle中substr函数的用法
- oracle中substr函数的用法
- oracle中substr函数的用法
- oracle中substr函数的用法
- Oracle中SubStr函数用法
- oracle中instr函数和substr函数的浅用法
- Oracle中substr的用法
- oracle中关于substr, translate函数的用法
- oracle中substr函数的用法(sqlserver right)
- Oracle substr函数用法
- Oracle substr函数用法
- oracle的substr函数的用法
- windows平台 fwrite写数据出错
- WINCE TOC解析
- 基于 Android NDK 的学习之旅-----数据传输(引用数据类型)
- ExtJS4中GridPanel组件简单例子
- TOMCAT内存溢出及大小调整
- oracle中substr函数的用法
- VS2005下SDL的编译链接问题
- uafxcwd.lib(afxmem.obj) : error LNK2005: "void * __cdecl operator new(unsigned int)" (??2@YAPAXI@Z)
- LINUX USB 系统(1)
- solr查询不使用query analyzer中文分词的问题解决
- 嵌入式开发资料集锦
- MinSdkVersion, targetSdkVersion, target API level的区别
- 产生时间字符串组
- 六、矩阵按键(4*4)