I have a document xml and i walt load it in table of xmltype.
LOAD DATA INFILE * INTO TABLE foo TRUNCATE XMLType(XMLDATA)( lobfn FILLER CHAR TERMINATED BY ',', XMLDATA LOBFILE(lobfn) TERMINATED BY EOF ) BEGINDATA C:\Users\xxx\Desktop\file.xml now, I want show the content of the file xml just now loaded from table . how you do?
select * from foo; ?? but this not show the content of the file xml, but only piece that xml.why?
No comments:
Post a Comment