Oracle 9iÖеÄXMLTYPEÓ¦ÓÃѧϰ
oracle´Ó9i¿ªÊ¼Ö§³ÖÒ»ÖÖеÄÊý¾ÝÀàÐÍ---- xmltype£¬ÓÃÓÚ´æ´¢ºÍ¹ÜÀíxmlÊý¾Ý£¬²¢ÌṩÁ˺ܶàµÄfunctions£¬ÓÃÀ´Ö±½Ó¶ÁÈ¡xmlÎĵµºÍ¹ÜÀí½Úµã¡£ÏÂÃ潫½éÉÜxmltypeµÄһЩ»ù±¾Ê¹Óá£
1.½¨Á¢º¬ÓÐ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.Ö±½Ó²éѯ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.¸üÐÂ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 9iÌṩµÄXMLÄÚÖÃÌØÐÔ£º
Oracle 9iÖ§³ÖXMLTypeÀàÐÍ£¬ËüÊÇÒ»ÖÖOracle 9iϵͳ¶¨ÒåµÄ¶ÔÏóÀàÐÍ¡£XMLTypeÓÐÄÚÖõĺ¯Êý£¬ÓÐÁ¦µÄÌṩÁËÍÆXMLµÄ´´½¨£¬Ë÷¼ì£¬Ë÷ÒýµÈ¹¦ÄÜ¡£
Óû§¿ÉÒÔʹÓÃSQLº¯Êý¶¯Ì¬µÄ²úÉúXMLÎĵµ¡£ÕâЩº¯ÊýÓУºSYS_XMLGENºÍSYS_XMLAGGºÍPL/SQL°üDBMS_XMLGEN¡£
XMLÌØÐÔ
ÃèÊö
XMLType
1¡¢XMLTypeÊÇoracleϵͳ¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬ÏµÍ³Ô¤¶¨ÒåÁËÄÚ²¿º¯ÊýÈ¥·ÃÎÊXMLÊý¾Ý¡£¿ÉÒÔÖ´ÐÐÏÂÃæµÄÈÎÎñ£º
2¡¢´´½¨XMLTypeÁУ¬ÔÚXMLTypeÁÐÉÏÃæʹÓÃÄÚÖõĺ¯Êý¡£
´´½¨PL/SQLº¯ÊýºÍ´æ´¢¹ý³Ì£¬¿ÉÒÔʹÓÃXMLType×÷Ϊ²ÎÊý´«È룬»òÕß×÷Ϊ·µ»Ø²ÎÊý´«³ö¡£
3¡¢ÔÚXMLTypeÁÐÉÏÃæ´æ´¢¡¢Ë÷Òý¡¢´¦ÀíXMLÊý¾Ý¡£
DBMS_XMLGEN
DBMS_XMLGENÊÇÒ»¸öPL/SQL°ü£
Ïà¹ØÎĵµ£º
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
ÔÚ´ò°üoralce¿Í»§¶Ëºó£¬¾³£»áÓöµ½Õâ¸öÎÊÌâ“specified class not registered in registry”
½â¾ö°ì·¨£º
ÕâÊÇÒòΪÓм¸¸öÁ´½Ó¿âdll»òocxûע²áµÄÔÒò£¬¾±¾È˲âÊÔΪÒÔÏÂ5¸öÎļþ£º
......
Ò» µÇ¼SQLPLUS
sqlplusÓû§Ãû/ÃÜÂë@Êý¾Ý¿âʵÀýasµÇ¼½ÇÉ«;
Èç:Óû§sys(ÃÜÂëΪ123)ÒÔsysdbaµÄ½ÇÉ«µÇ¼Êý¾Ý¿âORACL£¬ÎÒÃÇ¿ÉÒÔÊäÈ룺sqlplus sys/123@oracl as sysdba;
ÕâÖֵǼ·½Ê½»áÖ±½Ó±©Â¶ÃÜÂ룬Èç¹ûÏëÒþ²ØÃÜÂ룬¿ÉÒÔÔÚ´ËÊ¡ÂÔÃÜÂëµÄÊäÈ룬È磺sqlplus sys@oracl as sysdb ......
begin
sys.dbms_job.submit(job => :job,
what => 'check_err;',
  ......
ÔÚÀûÓÃNETWORK_LINK·½Ê½µ¼³öµÄʱºò£¬³öÏÖÁËÕâ¸ö´íÎó¡£
Ïêϸ´íÎóÐÅÏ¢ÈçÏ£º
bash-3.00$ expdp yangtk/yangtk directory=d_temp dumpfile=jiangsu.dp network_link=test113 logfile=jiangsu.log tables=cat_org
Export: Release11.1.0.6.0 - 64bit Production onÐÇÆÚ¶þ, 16 9ÔÂ, 2008 17:08:22
Copyright (c) 2003, 2007, ......