[9i XMLQuery] 샘플들... (기억에 남기기.. ㅡㅡ;; )

SELECT T.doc.extract('/MIX/Title/OriginalTitle/text()').getStringVal()    
FROM doc_xdoclong_km T
WHERE docid=646        

SELECT extractValue(T.doc, '/MIX/Title/OriginalTitle'),
           extractValue(T.doc, '/MIX/MusicIdentifier/KMID'),
           extract(T.doc, '/MIX/SongDetailInformation/RightsInformation').getStringVal()  
FROM doc_xdoclong_km T
WHERE docid=646

SELECT extract(T.doc, '/MIX').getStringVal()  
FROM doc_xdoclong_km T
WHERE docid=481

SELECT extract(T.doc, '/MIX/SongDetailInformation/RightsInformation/RightsType').getclobval() as result1,
           extract(T.doc, '/MIX/SongDetailInformation/RightsInformation/RightsID').getclobval() as result2,
           extract(T.doc, '/MIX/SongDetailInformation/RightsInformation/Name').getclobval() as result3
FROM doc_xdoclong_km T

SELECT T.doc.getClobVal() FROM doc_xdoclong_km T where docid=646

SELECT T.doc.extract('/MIX/Title/OriginalTitle/text()').getStringVal()    
FROM doc_xdoclong_km T
WHERE docid=646



***** 아름다운프로님에 의해서 게시물 복사 + 카테고리변경되었습니다 (2003-12-18 16:49)