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]
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Check out the new improvements in Yahoo! Groups email.
http://us.click.yahoo.com/6pRQfA/fOaOAA/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/
