熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

oracle中substr函數的用法

2013-11-13 22:17:48  來源: Oracle 

  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

  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 ) would return is

  substr(This is a test ) would return is a test

  substr(TechOnTheNet ) would return Tech

  substr(TechOnTheNet ) would return Net

  substr(TechOnTheNet ) would return The

  substr(TechOnTheNet ) would return On


From:http://tw.wingwit.com/Article/program/Oracle/201311/18708.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.