��XML�ĵ��ȡ��¼��

Article View: cn.bbs.comp.database

Article #8583

Back to cn.bbs.comp.database Previous Next

#8583

From: ��ң��
Date: Fri, 14 Nov 2003 11:41

13 lines
1155 bytes

select request_no,extractValue(value(t),'PT/ID')
  from t_outer_request a,
       table( xmlsequence(extract(xmltype(a.request_xml),'/REQUEST/BUSI/CONT
ENT/PTS/PT'
                                 )
                         )
            ) t
  where a.request_no in(2,3)


���Ի���Oracle9.2
--
[m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 61.165.203.201][m

Technical Details

Message-ID: <49GLBl$b0Y@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!elnk-pas-nf1!elnk-nf2-pas!newsfeed.earthlink.net!sjc70.webusenet.com!news.webusenet.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,GB
X-Google-Thread: 101948,4a54bfb33978d890,start
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-11-14 03:41:18 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!elnk-pas-nf1!elnk-nf2-pas!newsfeed.earthlink.net!sjc70.webusenet.com!news.webusenet.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!SJTU
From: hfzjz.bbs@bbs.sjtu.edu.cn (��ң����)
Newsgroups: cn.bbs.comp.database
Subject: ��XML�ĵ���ȡ��¼��
Date: 14 Nov 2003 11:41:52 GMT
Organization: ��ˮ˼Դ
Message-ID: <49GLBl$b0Y@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1068810047.A

Article View: cn.bbs.comp.database

��XML�ĵ���ȡ��¼��

��XML�ĵ��ȡ��¼��