How do I view CLOB in Dbvisualizer?

[s***@yahoo.com]

I'm using DBVISUALIZER. How can I edit the contents of a CLOB/BLOB
column that is originally text?

Thanks for your help.

[Stoyan]

I see it like that: (CLOB - 174 bytes). I have no idea how does one can
see the content.:-)

[s***@yahoo.com]

In the Free edition of DBVISUALIZER double clicking the clob field
opens a form displays
the column value pairs. I want to see the content in a CLOB. Is that
possible?
Some vendors have given tools to display images, but I don't have the
luxury of
using their pricey products.

Thanks

[DA Morgan]

Post by s***@yahoo.com
I'm using DBVISUALIZER. How can I edit the contents of a CLOB/BLOB
column that is originally text?
Thanks for your help.

Why don't you ask the people that wrote the product?
http://www.minq.se/products/dbvis/

[Stoyan]

Hello again:-)
I have just found a stupid way to show the values:
1.Open a data view over the table (by select or the table data viewer)
2.Select the CLOB values into the view (CLOB <N> bytes) that you would
like to view
3.Open the context menu over the selected values (right mouse button)
and choise "Export selection..." menu items
4.Parametrise the export. You can choise to export to a file or to the
clipboard.

That is!:-)

[s***@yahoo.com]

Hi Stoyan
I did what you suggested but it still does not export. Are you using
Free version 4.3.5 as I am using?

Thanks!

[Stoyan]

Hi,
Please check you e-mail (***@yahoo.com). There I have sent
you my jdbc driver and screen shots of the export.

Stoyan

[Stoyan]

For the jdbc driver the string format is like that:
jdbc:oracle:thin:@<server IP or name>:<server port (usually
1521)>:<sid>
Example:
jdbc:oracle:thin:@oracleDB:1521:test

[AnySQL (d.c.b.a)]

You can also use AnySQL to view LONG/LOB column, it's free Java based
tool.

Welcome, AnySQL
http://www.anysql.net/en/
http://www.anysql.net/en/anysql.html

[r***@minq.se]

Hi,

You can choose whether to show CLOBs by size or by value in Tool
Properties. Just open the Tools->Tool Properties menu choice. In the
category tree of properties locate and select Grid->Binary/BLOB and
CLOB Data. Now set the CLOB property to "By Value".

Hope this helps.

Regards

Roger
Minq Software (author of DbVisualizer)

Post by s***@yahoo.com
I'm using DBVISUALIZER. How can I edit the contents of a CLOB/BLOB
column that is originally text?
Thanks for your help.