OraFAQ Forum: Client Tools » How To Display XMLTYPE datatype contents in SQL* PLUS

Home » Other » Client Tools » How To Display XMLTYPE datatype contents in SQL* PLUS (Oracle9i(Database),Sql* Plus(8.1.7.0.0),Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How To Display XMLTYPE datatype contents in SQL* PLUS [message #316217]

Thu, 24 April 2008 05:23

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

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

ThomasG
Messages: 3212
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

rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA

Senior 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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 06:31:49 CST 2025