Re: [Squirrel-sql-users] data not showing in query result pane
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Jowers, T. <tim...@ve...> - 2007-06-11 13:41:33
|
Thanks Rob,=20 SquirreL is one of the best OpenSource apps I've ever used. I haven't used TOAD a single time so far on this project. Here's another workaround I used. getclobval(). "input" is the column name and is indeed an XMLType though in Oracle 9.2.0.1.0. select w.input.getclobval() from ws_report w where = operation=3D'addOrder' and success=3D0 and db_date_added > sysdate -1 Best wishes, =20 TimJowers -----Original Message----- From: squ...@li... [mailto:squ...@li...] On Behalf Of Robert Manning Sent: Saturday, June 09, 2007 2:23 PM To: Jowers, Tim Cc: squ...@li... Subject: Re: [Squirrel-sql-users] data not showing in query result pane On 6/8/07, Jowers, Tim <tim...@ve...> wrote: > I query a table with some XML input and XML output in it but do not get the > text from the database. I get something like: > > <Unknown(2,007)> > > > > Is there a way to change Squirrel to show the actual data? Sorry, there is no support for the SQL-2003 XML type yet. If you are using Oracle, then for now you can use XMLSERIALIZE(CONTENT(<xmltype>). For example: create table XMLTable (doc_id number, xml_data XMLType); insert into XMLTable values (1, XMLType('<FAQ-LIST><QUESTION><QUERY>Question 1</QUERY><RESPONSE>Answer goes here.</RESPONSE></QUESTION></FAQ-LIST>')); -- yields (Unknown 2,007) SELECT xml_data FROM XMLTable -- yields '<FAQ-LIST><QUESTION><QUERY>Question 1...' select XMLSERIALIZE(CONTENT xml_data) from XMLTable Rob ------------------------------------------------------------------------ - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |