oracleµ¼³öÊý¾Ýµ½xmlÖÐ - Oracle / »ù´¡ºÍ¹ÜÀí
ÏÖÔÚÎÒдÁË´æ´¢¹ý³Ì£¬°Ñ±íÀïÃæµÄÊý¾Ýµ¼³öµ½xmlÖУ¬ÏÖÔڵĸñʽÊÇ£º
<?xml version="1.0" encoding="GBK" ?>
<PEOPLE>
<PERSON PERSONID="1">
<NAME>1</NAME>
<ADDRESS>1</ADDRESS>
<TEL>1</TEL>
<FAX>1</FAX>
<EMAIL>1</EMAIL>
</PERSON>
</PEOPLE>
µ«ÊÇÎÒÏëµÃµ½µÄxmlµÄ¸ñʽÊÇÕâÑù£º
<?xml version="1.0" encoding="GBK" ?>
<PEOPLE>
<PERSON PERSONID="1">
<NAME DBSource="" tableSource="" fieldSource="" >1</NAME>
<ADDRESS DBSource="" tableSource="" fieldSource="" >1</ADDRESS>
<TEL DBSource="" tableSource="" fieldSource="" >1</TEL>
<FAX DBSource="" tableSource="" fieldSource="" >1</FAX>
<EMAIL DBSource="" tableSource="" fieldSource="" >1</EMAIL>
</PERSON>
</PEOPLE>
ÇëÎÊÎÒ¸ÃÔõô´¦ÀíºÃ£¿
²Î¿¼´æ´¢¹ý³ÌÈçÏ£º
CREATE OR REPLACE PROCEDURE JSBDATA.PROC_TOXML(result in out nocopy clob,
filename in varch
Ïà¹ØÎÊ´ð£º
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
ΪʲôÎҵijÌÐòµ÷ÓÃXMLÅäÖÃÎļþÖеİ¢À²®ÎÄÏÔʾ²»³öÀ´£¿ÆäËûµÄÓïÖÖ¶¼¿ÉÒÔ£¬ÈçÖÐÎÄ£¬Ó¢ÎÄ£¬µÂÎͼ¿É¡£
ÎÒ½«XMLµÄ±àÂë¸ÄΪutf-8ºÍunicodeµÄµ½µÃ½á¹û¶¼Ò»Ñù.
°¢À²®ÎĵÄ×Ö¿âÄãÓÐô£¿
ÓÐ,ÎÒµÄEXEÊÇ·ÅÔÚpc»úÉÏÖ´Ðе ......