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 <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]> 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 --------------------~-->
Great things are happening at Yahoo! Groups. See the new email design.
http://us.click.yahoo.com/TISQkA/hOaOAA/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/
