📄 解析 sql 中的字符串.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0095)http://www-900.ibm.com/developerWorks/cn/dmdd/library/techarticles/0303stolze/0303stolze1.shtml -->
<HTML xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE>解析 SQL 中的字符串</TITLE>
<META content="text/html; charset=GB2312" http-equiv=Content-Type>
<META content=index,follow name=ROBOTS>
<META content="解析 SQL 中的字符串" name=TITLE><!-- DB2 technology-->
<META
content="strings, db2 universal database, parse data, linux, unix, windows, knut stolze for loops, recursive queries, sql pl, java, c++, database partitions, ese, delimiters, 字符串, DB2 通用数据库, 解析数据, 递归查询, 数据库分区, 定界符"
name=KEYWORDS>
<META content=本文展示了如何解析数据字符串，另外还展示对结果进行后续处理的一些可能性。 name=ABSTRACT>
<META content=本文展示了如何解析数据字符串，另外还展示对结果进行后续处理的一些可能性。 name=DESCRIPTION>
<META content=2003-03-27 name=DC.DATE scheme="iso8601">
<META content=2003-03-27 name=LASTUPDATE>
<META content="" name=dmdd_product_family>
<META content="" name=dmdd_products>
<META content="" name=dmdd_topics>
<META content="" name=dmdd_content_type>
<META content=DMDD name=zone><!-- BEGIN head.ssi INCLUDE FILE -->
<META
content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 cn 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0))'
http-equiv=PICS-Label>
<META content=Public name=security>
<META content=GB2312 name=charset>
<META content=cn name=IBM.COUNTRY>
<META content=zh-cn name=DC.LANGUAGE scheme="rfc1766">
<META content="Copyright (c) 2002 by IBM Corporation" name=copyright>
<META content=/websphere/ratings.nsf/cn_db2dd_feedback name=owner>
<META content=index,follow name=robots>
<META content=V11 name=source><LINK href="解析 SQL 中的字符串.files/dd.css"
rel=stylesheet type=text/css>
<SCRIPT language=JavaScript src="解析 SQL 中的字符串.files/checkall.js">
<SCRIPT LANGUAGE="JavaScript">
<!--
function nsResize() {
if (navigator.appName.indexOf("Netscape") != -1) {
if ( (parseFloat(navigator.appVersion) < 4.05) ||
(parseFloat(navigator.appVersion) > 4.08) )
location.reload(true);
}
}
// -->
</SCRIPT>
<!-- END head.ssi INCLUDE FILE -->
<META content="MSHTML 5.00.3526.800" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff leftMargin=2 topMargin=2 marginwidth="2" marginheight="2"><!-- MASTHEAD -->
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD class=tbgc width=150><A href="http://www.ibm.com/"><IMG alt=IBM
border=0 height=47 src="解析 SQL 中的字符串.files/lanim.gif" width=150></A></TD>
<TD class=tbg width=310><A
href="http://www-900.ibm.com/developerWorks/cn/dmdd/library/techarticles/0303stolze/0303stolze1.shtml#main"><IMG
alt="Skip to main content" border=0 height=1
src="解析 SQL 中的字符串.files/c.gif" width=310></A><SPAN
class=country>中国</SPAN></TD>
<TD align=right class=tbgc vAlign=top width="100%">
<TABLE border=0 cellPadding=0 cellSpacing=0>
<FORM action=http://www-106.ibm.com/search/searchResults.jsp id=form1
method=get name=form1>
<TBODY>
<TR>
<TD colSpan=7><IMG alt="" border=0 height=4
src="C:\Documents and Settings\hjh1\桌面\db2 语法参考\解析 SQL 中的字符串.files\c(1).gif"
width=390></TD></TR>
<TR vAlign=center>
<TD class=dwsearch><NOBR><FONT
color=#ffffff><B>搜索:</B></FONT></NOBR> </TD>
<TD><INPUT class=dwsearch maxLength=100 name=query size=23></TD>
<TD class=dwsearch vAlign=center> <FONT
color=#ffffff><B>在</B></FONT> </TD>
<TD class=dwsearch><SELECT class=dwsearch2
name=searchScope> <OPTION selected value=dW>dW
全部内容</OPTION> <OPTION value=javaZ> Java 技术</OPTION> <OPTION
value=linuxZ> Linux</OPTION> <OPTION
value=opensrcZ> 开放源码</OPTION> <OPTION
value=securityZ> 安全</OPTION> <OPTION value=webservZ> Web
服务</OPTION> <OPTION value=xmlZ> XML</OPTION> <OPTION
value=dW>.................</OPTION> <OPTION
value=dmdd> DB2</OPTION> <OPTION
value=wsdd> WebSphere</OPTION> <OPTION
value=lotusdd> Lotus 专题</OPTION> <OPTION
value=tivolidd> Tivoli 专题</OPTION> <OPTION
value=dW>.................</OPTION> <OPTION value=all>IBM
全部内容</OPTION></SELECT></TD>
<TD><IMG alt="" border=0 height=1
src="C:\Documents and Settings\hjh1\桌面\db2 语法参考\解析 SQL 中的字符串.files\c(1).gif"
width=5></TD>
<TD><INPUT alt="Search button" border=0 height=23 name=Search
src="解析 SQL 中的字符串.files/search.gif" type=image value=Search
width=64></TD>
<TD vAlign=top><IMG alt="" border=0 height=1
src="C:\Documents and Settings\hjh1\桌面\db2 语法参考\解析 SQL 中的字符串.files\c(1).gif"
width=30></TD></TR>
<TR vAlign=top>
<TD> </TD>
<TD class=dwsearch> <FONT color=#ffffff>只用 + - " "
( )</FONT>
<TD> </TD>
<TD> </TD>
<TD> </TD>
<TD> </TD>
<TD> </TD></TR><INPUT name=searchType type=hidden value=1> <INPUT
name=searchSite type=hidden value=dWChina> <INPUT name=pageLang
type=hidden value=zh> <INPUT name=langEncoding type=hidden value=gb2312>
</FORM></TBODY></TABLE></TD></TR>
<TR>
<TD class=hbg height=21 width=150> </TD>
<TD class=bbg colSpan=2 height=21 vAlign=top> <A
class=mainlink
href="http://www-900.ibm.com/developerWorks/cn/cgi-bin/click.cgi?url=http://www-900.ibm.com/cn/&origin=dm">IBM
主页</A><SPAN class=divider> | </SPAN><A
class=mainlink
href="http://www-900.ibm.com/developerWorks/cn/cgi-bin/click.cgi?url=http://www-900.ibm.com/cn/products/index.shtml&origin=dm">产品与服务</A><SPAN
class=divider> | </SPAN><A class=mainlink
href="http://www-900.ibm.com/developerWorks/cn/cgi-bin/click.cgi?url=http://www-900.ibm.com/cn/support/index.shtml&origin=dm">支持与下载</A><SPAN
class=divider> | </SPAN><A class=mainlink
href="http://www-900.ibm.com/developerWorks/cn/cgi-bin/click.cgi?url=http://www-900.ibm.com/cn/account/index.shtml&origin=dm">个性化服务</A></TD></TR></TBODY></TABLE><!-- START BODY -->
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR colspan="3">
<TD width=8><!-- gutter --><IMG height=1
src="C:\Documents and Settings\hjh1\桌面\db2 语法参考\解析 SQL 中的字符串.files\c(1).gif"
width=8></TD>
<TD><!-- bread crumb trail ***** --><!-- BANNER -->
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD width="100%"><A class=bctl
href="http://www-900.ibm.com/developerWorks/cn/dmdd/index.shtml">DB2
开发者园地</A><SPAN class=bct> > </SPAN> <A class=bctl
href="http://www-900.ibm.com/developerWorks/cn/cndmdd.nsf/db2-content-bynew?openview&count=10">所有文章</A><SPAN
class=bct> > </SPAN><BR><BR></TD></TR></TBODY></TABLE><!-- ***** DO NOT EDIT THE FOLLOWING CODE ***** --></TD>
<TD width=8><IMG height=1
src="C:\Documents and Settings\hjh1\桌面\db2 语法参考\解析 SQL 中的字符串.files\c(1).gif"
width=8></TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD vAlign=top width=8><!-- gutter --><IMG height=1
src="C:\Documents and Settings\hjh1\桌面\db2 语法参考\解析 SQL 中的字符串.files\c(1).gif"
width=8> </TD>
<TD vAlign=top>
<TABLE align=right border=0 cellPadding=0 cellSpacing=0 width=156>
<TBODY>
<TR>
<TD bgColor=#ffffff vAlign=bottom><A
href="http://www-900.ibm.com/developerWorks/cn/dmdd/library/techarticles/0303stolze/0303stolze1_eng.shtml">英文原文</A></TD></TR></TBODY></TABLE><!-- ***** comments #5: enter the Title, subtitle, author name, job title, and month/year article was initially published ***** --><BR>
<P><STRONG class=title>解析 SQL 中的字符串</STRONG><BR></P><!--strong class="subtitle">Enter a subtitle</strong><br-->
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR vAlign=top>
<TD><!-- author info begin-->
<P class=standard><A
href="http://www-900.ibm.com/developerWorks/cn/dmdd/library/techarticles/0303stolze/0303stolze1.shtml#authorname">Knut
Stolze</A> <BR>IBM 信息集成<BR>IBM 德国</P><!-- author inof end--></TD></TR>
<TR>
<TD bgColor=#000000><IMG height=3
src="C:\Documents and Settings\hjh1\桌面\db2 语法参考\解析 SQL 中的字符串.files\c(1).gif"
width=156></TD></TR>
<TR>
<TD> </TD></TR></TBODY></TABLE><!-- END title and author lines --><!-- sidebar table of contents begins -->
<TABLE align=right border=0 cellPadding=0 cellSpacing=0 width=156>
<TBODY>
<TR>
<TD align=middle class=tblue height=16 vAlign=center
width=5> </TD>
<TD class=tblue height=16 width=149>内容</TD>
<TD align=middle class=tblue height=16 vAlign=center
width=2> </TD></TR>
<TR class=ddb1>
<TD colSpan=3><IMG alt="" border=0 height=8
src="C:\Documents and Settings\hjh1\桌面\db2 语法参考\解析 SQL 中的字符串.files\c(1).gif"
width=100> </TD></TR>
<TR class=ddb1 vAlign=top>
<TD class=dwsmall colSpan=3><A
href="http://www-900.ibm.com/developerWorks/cn/dmdd/library/techarticles/0303stolze/0303stolze1.shtml#0">简介</A></TD></TR>
<TR class=ddb1>
<TD colSpan=3><IMG alt="" border=0 height=8
src="C:\Documents and Settings\hjh1\桌面\db2 语法参考\解析 SQL 中的字符串.files\c(1).gif"
width=100> </TD></TR>
<TR class=ddb1 vAlign=top>
<TD class=dwsmall colSpan=3><A
href="http://www-900.ibm.com/developerWorks/cn/dmdd/library/techarticles/0303stolze/0303stolze1.shtml#1">迭代字符串</A></TD></TR>
<TR class=ddb1>
<TD colSpan=3><IMG alt="" border=0 height=8
src="C:\Documents and Settings\hjh1\桌面\db2 语法参考\解析 SQL 中的字符串.files\c(1).gif"
width=100> </TD></TR>
<TR class=ddb1 vAlign=top>
<TD class=dwsmall colSpan=3><A
href="http://www-900.ibm.com/developerWorks/cn/dmdd/library/techarticles/0303stolze/0303stolze1.shtml#2">抽取子字符串</A></TD></TR>
<TR class=ddb1>
<TD colSpan=3><IMG alt="" border=0 height=8
src="C:\Documents and Settings\hjh1\桌面\db2 语法参考\解析 SQL 中的字符串.files\c(1).gif"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -