Oracle ¹ØÏµ±íÖд洢XML½á¹¹µÄÊý¾Ý
×î½ü×ö¸öÏîÄ¿£¬Ç°Ì¨ÎÒÓõÄflex ÓÃjavaÁ¬½ÓµÄOracle ÏÖÔÚÎÊÌâÊÇÕâÑùµÄ ÎÒÉú³ÉÒ»¸öxml½á¹¹µÄÊý¾Ý È»ºóÓÃtoXMLString½«Ëüת»»ÁËÏ£¬´æÈëOracleÖеĹØÏµÊý¾Ý¿âÖУ¬XMLÊý¾Ý²»ÊǺܳ¤Ê± ¿ÉÒÔ±£´æ³É¹¦ ¿ÉÊÇXMLÊý¾Ý³¬¹ýÒ»¶¨³¤¶Èºó¾Í±£´æ²»ÁË
ºóÀ´ ÎÒÓÖÊÔ×ŰÑÒ»¸öºÜ³¤µÄXMLÊý¾ÝÏȷŵ½Êý¾Ý¿âÖÐ ½á¹ûǰ̨ÊÇÄܰÑËü¶Á³öÀ´ÁË ÎÒÏÖÔÚ²»ÖªµÀΪʲô»áÕâÑù Çó¸ßÊÖ¸øµãÒâ¼û ÆäÖдæxmlÊý¾ÝµÄÏîÎÒÓõÄÊÇCLOB
¹Ø×¢ÖÐ
ûÃ÷°×ÄãµÄÎÊÌ⣿
ÄãÒ»¿ªÊ¼²»Äܴ棬ºóÀ´¿ÉÒÔ´æÁË£¿ÄÇÄã²»ÄÜ´æµÄʱºò±¨Ê²Ã´´í°¡£¿
лл¥É쵀 ÎÒÃ÷°×ÁË~~~ÕæµÄºÜлл
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
score±í
scoreid course studentid score
1 Êýѧ 2 99
2 Êýѧ 3 60
3 Êýѧ 4 80
4 ÓïÎÄ 5 79
5 ÓïÎÄ 6 58
6 ÓïÎÄ 1 66
7 Ó¢Óï 6 76
8 Ó¢Óï 4 87
9 Ó¢Óï 3 100
10Ó¢Óï 2 69
ÔõÑùµÃµ½Ã»ÃÅ¿ÎÖзÖÊý×î¸ßµÄÄÇ ......