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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
1¡£select * from a where a.rowid=(select min(b.rowid) from b where a.id=b.id);
create test1(
nflowid number primary key,
ndocid number,
drecvdate date);
insert into test1 values (1, 12301, sysdate) ;
insert into test1 values (2, 12301, sysdate);
select * from test1 order by drecvdate:
......
ÏîÄ¿´ÓmysqlÇ¨ÒÆµ½ORACLEÖÐÓöµ½ÒÆÖ²ÎÊÌ⣬mysqlÖÐÖ§³Ölimit ¶øORACLE say no .
½â¾ö·½·¨ ÀûÓÃORACLEµÄαÁÐ rownumÀ´¿ØÖÆ¡£¡£
Mysql : select * from table limit 10
equl
ORACLE£º select * from table where rownum <= 10
ORACLE αÁнéÉÜ£º
ËæÊý¾Ý×ÖµäÒ»Æð×Ô¶¯´´½¨µÄÒ»¸ö±í,ÊôÓÚsysģʽ,ÈκÎÓû§¶¼¿ÉÒÔ·ÃÎÊ,&nbs ......
Redhat
as4 + oracle 10g(10.2.0)
+ freeradius1.1.2+ tomcat5.5
*****************************
±¾ÎÄĿ¼
********************************
Ò»¡¢°²×°
redhat as4
¶þ¡¢°²×°
oracle 10g
£¨
10201_database_linux32.zip
£©
£¨Ò»£©¼ì²é
oracle 10g
ËùÐèµÄ°ü×é¼þ£º
£¨¶þ£©ÉèÖÃϵͳ²ÎÊ ......
sql serverºÍoracleÐÐתÁеÄÒ»ÖÖµäÐÍ·½·¨
ǰÑÔ£ºÍøÉÏÓв»ÉÙÎÄÕÂÊǽ²ÐÐתÁе쬵«ÊǴ󲿷ֶ¼ÊÇÖ±½ÓÌù´úÂ룬ºöÊÓÁËÖмä¹ý³Ì£¬±¾ÈË×Ô¼ºË¼¿¼ÁËÏÂΪʲôҪÕâÑùʵÏÖ£¬²¢ÇÒ×öÁËÈçϵıʼǣ¬¶ÔÓÐЩ¶®µÄÈËÀ´Ëµ¿ÉÄÜûÓмÛÖµ£¬Ï£Íû¶Ô»¹²»¶®µÄÈËÓÐÒ»µã½è¼øÒâÒå¡£
¶ÔÓÚÓÐЩҵÎñÀ´Ëµ£¬Êý¾ÝÔÚ±íÖеĴ洢ºÍÆä×îÖÕµÄGrid±íÏÖÇ¡ºÃÏ൱ÓÚ°ÑÔ ......