Pada contoh yg pernah saya berikan asumsinya adalah data XML disimpan apa adanya di sebuah field.
Kalau anda ingin menyimpan data sesuai dgn tag yg ada, mau tidak mau harus menggunakan XML Parser (bisa Java, PL/SQL)sebelum load ke table. Bowo --- In [email protected], Teguh <[EMAIL PROTECTED]> wrote: > > Kalo boleh tahu juga untuk create table di Oracle yang fieldnya langsung sesuai dengan tag di XML bisa tdk. > Apakah ini berlaku untuk oracle 10G > > ----- Original Message ----- > From: Yulius Wibowo > To: [email protected] > Sent: Wednesday, June 28, 2006 8:24 AM > Subject: [indo-oracle] Re: Import XML FILE > > > > Anda bisa menggunakan beberapa cara, a.l: > 1. Menggunakan INSERT statement > 2. Menggunakan PL/SQL > 3. Menggunakan Java stored procedure or external > 4. Menggunakan SQL*Loader > 5. Menggunakan programming language lainnya spt C/C++/C#/VB > > Saya beri contoh menggunakan INSERT statement > - Misal , anda memiliki sebuah file XML "test.xml" di D:\data, > dengan isi sbb: > <EMPS> > <EMP> > <EMPNO>1234</EMPNO> > <ENAME>JOKO</ENAME> > <JOB>MANAGER</JOB> > </EMP> > <EMP> > <EMPNO>5678</EMPNO> > <ENAME>BUDI</ENAME> > <JOB>SALES</JOB> > </EMP> > </EMPS> > > dan akan anda load ke dalam sebuah table : "tbl_xml(col1 XMLType)" > > Kalau anda menggunakan Database 10G, > SQL> CREATE DIRECTORY mydir AS 'D:\DATA'; > SQL> INSERT INTO tbl_xml VALUES(XMLType(bfilename > ('MYDIR','test.xml'))); > SQL> SELECT * FROM tbl_xml; > > Tapi kalau anda masih menggunakan Database 9i (misal Rel. 2, 9.2.0) > Terlebih dulu buat fungsi sbb: > > SQL> CREATE OR REPLACE FUNCTION getFileContent(directoryName > varchar2 default 'MYDIR', > filename varchar2, > charset varchar2 default 'AL32UTF8') > return CLOB > is > fileContent CLOB := NULL; > file bfile := bfilename(directoryName,filename); > dest_offset number := 1; > src_offset number := 1; > lang_context number := 0; > conv_warning number := 0; > begin > DBMS_LOB.createTemporary(fileContent,true,DBMS_LOB.SESSION); > DBMS_LOB.fileopen(file, DBMS_LOB.file_readonly); > DBMS_LOB.loadClobfromFile > ( > fileContent, > file, > DBMS_LOB.getLength(file), > dest_offset, > src_offset, > nls_charset_id(charset), > lang_context, > conv_warning > ); > DBMS_LOB.fileclose(file); > return fileContent; > end; > / > > SQL> INSERT INTO tbl_xml VALUES(XMLType(getFileContent > ('MYDIR','test.xml'); > > SQL> SELECT * FROM tbl_xml; > > CMIIW, > > Bowo > > --- In [email protected], braveheart <my.braveheart@> > wrote: > > > > saya pernah coba pakai XMLTYPE, tidak perlu instalasi tambahan > seperti > > halnya kalau pakai XML Schema. File XML bisa diquery seperti > halnya table > > yang lain meski cara querynya agak beda. Dokumentasi Oracle sdh > menjelaskan > > dengan gamblang, search aja dg keyword : XMLTYPE > > > > On 6/23/06, gue aja <why_u81@> wrote: > > > > > > hallo group, saya mau tanya neech; > > > > > > - Bagaimana caranya import file XML ke dalam Oracale database? > > > - Apakah ada cara dari pl/sql atau dari enterprise console? > > > - Apakah kita harus buat schemanya terlebih dahulu? > > > > > > Jika ada yang pernah melakukannya, mohon bantuannya...... > > > > > > Thanx > > > > > > Wahyu Laksono > > > > > > > > > --------------------------------- > > > Do you Yahoo!? > > > Next-gen email? Have it all with the all-new Yahoo! Mail Beta. > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > -- > > ---------------------------------------------------------- > ---------------------------------------------------------- > -- > > >> Semulia-mulia kekayaan milik pribadi adalah meninggalkan banyak > keinginan > > [Imam Ali r.a] > > >> Everyone dies, but not everyone really lives [William Wallace, > > Braveheart] > > >> Death come to us all ... [Princess Wales, Braveehart] > > ---------------------------------------------------------- > ---------------------------------------------------------- > -- > > > > > > [Non-text portions of this message have been removed] > > > > > > #ygrp-mlmsg { FONT-SIZE: small; FONT-FAMILY: arial,helvetica,clean,sans-serif}#ygrp-mlmsg TABLE { }#ygrp-mlmsg SELECT { FONT: 99% arial,helvetica,clean,sans-serif}INPUT { FONT: 99% arial,helvetica,clean,sans-serif}TEXTAREA { FONT: 99% arial,helvetica,clean,sans-serif}#ygrp-mlmsg PRE { FONT: 100% monospace}CODE { FONT: 100% monospace}#ygrp- mlmsg { LINE-HEIGHT: 1.22em}#ygrp-text { FONT-FAMILY: Georgia}#ygrp-text P { MARGIN: 0px 0px 1em}#ygrp-tpmsgs { CLEAR: both; FONT-FAMILY: Arial}#ygrp-vitnav { FONT-SIZE: 77%; MARGIN: 0px; PADDING-TOP: 10px; FONT-FAMILY: Verdana}#ygrp- vitnav A { PADDING-RIGHT: 1px; PADDING-LEFT: 1px; PADDING- BOTTOM: 0px; PADDING-TOP: 0px}#ygrp-actbar { CLEAR: both; MARGIN: 25px 0px; COLOR: #666; WHITE-SPACE: nowrap; TEXT-ALIGN: right}#ygrp- actbar .left { FLOAT: left; WHITE-SPACE: nowrap}..bld { FONT- WEIGHT: bold}#ygrp-grft { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 15px; PADDING-TOP: 15px; FONT- FAMILY: > Verdana}#ygrp-ft { PADDING-RIGHT: 0px; BORDER-TOP: #666 1px solid; PADDING-LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 5px; PADDING-TOP: 5px; FONT-FAMILY: verdana}#ygrp-mlmsg #logo { PADDING-BOTTOM: 10px}#ygrp-vital { PADDING-RIGHT: 0px; PADDING-LEFT: 8px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 8px; PADDING- TOP: 2px; BACKGROUND-COLOR: #e0ecee}#ygrp-vital #vithd { FONT- WEIGHT: bold; FONT-SIZE: 77%; TEXT-TRANSFORM: uppercase; COLOR: #333; FONT-FAMILY: Verdana}#ygrp-vital UL { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 2px 0px; PADDING- TOP: 0px}#ygrp-vital UL LI { CLEAR: both; BORDER-RIGHT: #e0ecee 1px solid; BORDER-TOP: #e0ecee 1px solid; BORDER-LEFT: #e0ecee 1px solid; BORDER-BOTTOM: #e0ecee 1px solid; LIST-STYLE-TYPE: none}#ygrp- vital UL LI .ct { PADDING-RIGHT: 0.5em; FONT-WEIGHT: bold; FLOAT: right; WIDTH: 2em; COLOR: #ff7900; TEXT-ALIGN: right}#ygrp- vital UL LI .cat { FONT-WEIGHT: bold}#ygrp-vital A { TEXT- DECORATION: none}#ygrp-vital A:hover { > TEXT-DECORATION: underline}#ygrp-sponsor #hd { FONT-SIZE: 77%; COLOR: #999}#ygrp-sponsor #ov { PADDING-RIGHT: 13px; PADDING- LEFT: 13px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 6px; PADDING-TOP: 6px; BACKGROUND-COLOR: #e0ecee}#ygrp-sponsor #ov UL { PADDING- RIGHT: 0px; PADDING-LEFT: 8px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px}#ygrp-sponsor #ov LI { PADDING-RIGHT: 0px; PADDING- LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 6px; PADDING-TOP: 6px; LIST-STYLE-TYPE: square}#ygrp-sponsor #ov LI A { FONT-SIZE: 130%; TEXT-DECORATION: none}#ygrp-sponsor #nc { PADDING-RIGHT: 8px; PADDING-LEFT: 8px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 0px; PADDING- TOP: 0px; BACKGROUND-COLOR: #eee}#ygrp-sponsor .ad { PADDING- RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 8px; PADDING-TOP: 8px} #ygrp-sponsor .ad #hd1 { FONT-WEIGHT: bold; FONT-SIZE: 100%; COLOR: #628c2a; LINE-HEIGHT: 122%; FONT-FAMILY: Arial}#ygrp- sponsor .ad A { TEXT-DECORATION: none}#ygrp-sponsor .ad A:hover { TEXT-DECORATION: > underline}#ygrp-sponsor .ad P { MARGIN: 0px}o { FONT-SIZE: 0px}..MsoNormal { MARGIN: 0px}#ygrp-text TT { FONT-SIZE: 120%}BLOCKQUOTE { MARGIN: 0px 0px 0px 4px}..replbq { } > > --------------------------------- > Apakah Anda Yahoo!? > Kunjungi halaman depan Yahoo! Indonesia yang baru! > > [Non-text portions of this message have been removed] > ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
