Home » SQL & PL/SQL » Client Tools » How To Display XMLTYPE datatype contents in SQL* PLUS (Oracle9i(Database),Sql* Plus(8.1.7.0.0),Windows XP)
How To Display XMLTYPE datatype contents in SQL* PLUS [message #316217] Thu, 24 April 2008 05:23 Go to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Dear all,

How to display xmltype datatype contents as xml in sqlplus.
I am using database oracle 9i(9.2.0.6.0) but my sql plus
version is 8.1.7.0.0.

when i query it returns rows in this form:-

    SQL> select xmlorder from orders;
         XMLORDER()
         ---------------
         XMLTYPE()


instead of xmltype() i wan't to display XML File.

Thanks & Regards,
Rajat ratewal

Re: How To Display XMLTYPE datatype contents in SQL* PLUS [message #316221 is a reply to message #316217] Thu, 24 April 2008 05:34 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member

You can use the getClobVal() or getStringVal() member functions of the XML type.

Re: How To Display XMLTYPE datatype contents in SQL* PLUS [message #316236 is a reply to message #316221] Thu, 24 April 2008 06:12 Go to previous message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Thanks ThomasG.It worked

Previous Topic: Error N' is not a valid integer value 11g with toad 8.5.3
Next Topic: SQLPLUSW spooling
Goto Forum:
  


Current Time: Wed Dec 07 12:52:46 CST 2016

Total time taken to generate the page: 0.20948 seconds