Wednesday, December 23, 2009

XML Data : loading xml data into xml table and retrieving the same

LOAD DATA
INFILE *
INTO TABLE po_tab
APPEND
XMLTYPE (xmldata)
FIELDS
(xmldata CHAR(2000))

create table abc (a xmltype)

select * from abc

insert into abc values (xmltype('234tt'))

select extractvalue(a,'/st/b') "aaa" from abc

No comments:

Post a Comment