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
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......
<?xml version="1.0" encoding="utf-8" ?>
- <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical&q ......
Private Sub Command1_Click()
Dim MyString() As String
Open "a.xml" For Binary As #1 ' ´ò¿ª¸Õ´´½¨µÄÎļþ¡£
ReDim MyString(LOF(1) - 1)
Put #1, , MyRecord ' ¶ÁÈëËùÓÐ×Ö·ûµ½±äÁ¿ÖÐ ......