XML : loader xml with sql loader in table of xmltype and show xml from table

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