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