Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle xmltype¼ò½é

ÕÒ²»µ½Ô­ÌûÁË  ¾ÍÌùÕâÀï°É£¡
ÔÚÏò´ó¼ÒÏêϸ½éÉÜOracle֮ǰ£¬Ê×ÏÈÈôó¼ÒÁ˽âÏÂOracle xmltypeÊÇʲô£¬Oracle´Ó9i¿ªÊ¼Ö§³ÖÒ»ÖÖеÄÊý¾ÝÀàÐÍ----
xmltype£¬ÓÃÓÚ´æ´¢ºÍ¹ÜÀíxmlÊý¾Ý£¬²¢ÌṩÁ˺ܶàµÄfunctions£¬ÓÃÀ´Ö±½Ó¶ÁÈ¡xmlÎĵµºÍ¹ÜÀí½Úµã¡£ÏÂÃæ½«½éÉÜOracle
xmltypeµÄһЩ»ù±¾Ê¹Óá£
1.½¨Á¢º¬ÓÐOracle xmltypeÊý¾ÝÀàÐ͵ıícreate table abc (id number,xmldoc
sys.xmltype);ÉùÃ÷xmltypeÐÍ×Ö¶ÎÓÃ:sys.xmltype¡£
2.Ïò´øÓÐxmltypeÀàÐ͵ıí²åÈë´øÓÐÊý¾Ýinsert into abc (id,xmldoc) value (abc.nextval ,
sys.xmlType.createXML(''<name><a id="1" value="some
values">abc</a></name>'') );²åÈëÓÃ
sys.xmlType.createXML(''some xml doc'')
3.Ö±½Ó²éѯOracle xmltype×Ö¶ÎÀïÃæµÄÄÚÈݵõ½id=1µÄvalue±äÁ³µÄÖµselect
i.xmldoc.extract(''//name/a[@id=1]/@value'').getStringVal() as ennames,
id from abc iµÃµ½a½ÚµãµÄÖµselect id,
i.xmldoc.extract(''//name/a/text()'').getStringVal() as truename from
abc iµÃµ½½ÚµãidÊôÐÔµÄÖµSelect
hd.Data_t.extract(''/root/name/@id'').getStringVal()    As Name from
sehr_house_data hd
4.¸üÐÂOracle xmltypeÀïÃæµÄÊý¾Ýupdate abc set
xmldoc=updateXML(xmldoc,''//name/a[@id=1]/@value'',''some new value'')
where ......(×¢Ò⣺Èç¹ûÀïÃæÃ»ÓÐ<a id="1">Õâ¸ö½Úµã£¬½«²»ÄÜupdate)
5.Ìí¼Ó³¬¹ý4k×Ö½ÚµÄxmlÎĵµµ½xmltypeÐÍ×ֶοÉÒÔͨ¹ýʹÓÃÁÙʱ±íµÄ°ì·¨ÊµÏÖ£º
¡ôÏȽ¨Á¢Ò»¸öÁÙʱµÄ±í£¬ÆäÖеÄÒ»¸ö×Ö¶ÎÊÇclob
ÀàÐÍ£»
¡ôÔÙ½«ÒªÐ´Èëxmltype×ֶεÄxml docдÈëÕâ¸öÁÙʱµÄclobÐ͵Ä×Ö¶ÎÖУ»
¡ô×îºóinsert into abc
(id,xmldoc) values (abc_q.nextval , sys.xmlType.createXML((select
content from ÁÙʱ±í where id=......)));


Ïà¹ØÎĵµ£º

Ò»¸öoracle SIDÅäÖÃÎÊÌâµÄ´¦Àí

ORA-24324: δ³õʼ»¯·þÎñ¾ä±ú
ORA-01041: ÄÚ²¿´íÎó, hostdef À©Õ¹Ãû²»´æÔÚ
¿´ÁËÒÔÏÂÎÄÕ£¬ÔòÐ޸쬵«Ð޸ĺóÎÞ·¨Æô¶¯listener£¬ÓÚÊÇÏëµ½ÔÚnet assistanceÖÐÐ޸ģ¬Íê³É£º
ÅäÖÃΪÒÔϲÅÄÜÕýÈ·Æô¶¯listener£º
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (S ......

oracle ·ÖÇø²ð·Ö ²»ÄܲåÈëÊý¾Ý 01502 Ë÷ÒýʧЧ

Êý¾Ý±íday_energyµ±Ç°ÎªÔ·ÖÇø±í£¬·ÖÇøÐÅÏ¢ÈçÏ£ºDE_200912,DE_201001,DE_201002.....,Ô·ÖÇø±í³öÏÖËٶȲéѯÂý£¬Òò´Ëͨ¹ý½¨Á¢ÈÕ·ÖÇø±í½øÐиÄÉÆ¡£
²ð·ÖÔ·ÖÇø±íµÄÓï¾äΪ£º
alter table day_energy split partition de_201001 at('20100102') into (partition de_20100101,partition de_20100102)
·ÖÎö£º
alter table ±íà ......

OracleµÄrownumÔ­ÀíºÍʹÓÃ

Ô­Îijö×Ô£ºhttp://tenn.javaeye.com/blog/99339
ÔÚOracle
ÖУ¬Òª°´Ìض¨Ìõ¼þ²éѯǰNÌõ¼Ç¼£¬Óøörownum
¾Í¸ã¶¨ÁË¡£ 
select * from emp where rownum
 <= 5 
¶øÇÒÊéÉÏÒ²¸æ½ë£¬²»ÄܶÔrownum
ÓÃ">"£¬ÕâÒ²¾ÍÒâζ×Å£¬Èç¹ûÄãÏëÓÃ
 
select * from emp where rownum
&nbs ......

Oracle Finalizes Acquisition of Sun


We are pleased to announce that Oracle has completed its acquisition of Sun Microsystems and Sun is now a wholly owned subsidiary of Oracle. With this news, we want to reiterate our commitment to deliver complete, open and integrated systems that help our customers improve the performance, reliabi ......

oracle´¥·¢Æ÷

´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ËüÔÚ²åÈ룬ɾ³ý»òÐÞ¸ÄÌØ¶¨±íÖеÄÊý¾Ýʱ´¥·¢Ö´ÐУ¬Ëü±ÈÊý¾Ý¿â±¾Éí±ê×¼µÄ¹¦ÄÜÓиü¾«Ï¸ºÍ¸ü¸´ÔÓµÄÊý¾Ý¿ØÖÆÄÜÁ¦¡£Êý¾Ý¿â´¥·¢Æ÷ÓÐÒÔϵÄ×÷Óãº
¡¡¡¡* °²È«ÐÔ¡£¿ÉÒÔ»ùÓÚÊý¾Ý¿âµÄֵʹÓû§¾ßÓвÙ×÷Êý¾Ý¿âµÄijÖÖȨÀû¡£
¡¡¡¡# ¿ÉÒÔ»ùÓÚʱ¼äÏÞÖÆÓû§µÄ²Ù×÷£¬ÀýÈç²»ÔÊÐíϰàºóºÍ½Ú¼ÙÈÕÐÞ¸ÄÊý¾Ý¿âÊý¾Ý¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ