Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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: 97
Registered: March 2008
Location: INDIA
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
Report message to a moderator
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: 620
Registered: April 2005
Location: Heilbronn, Germany
Senior Member

You can use the getClobVal() or getStringVal() member functions of the XML type.
Report message to a moderator
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: 97
Registered: March 2008
Location: INDIA
Member
Thanks ThomasG.It worked
Report message to a moderator
Previous Topic:Error N' is not a valid integer value 11g with toad 8.5.3
Next Topic:SQLPLUSW spooling
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 00:13:37 CDT 2008

Total time taken to generate the page: 0.49583 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.