How can I read blob data in Oracle SQL Developer. It is stored in byte[] format. Is there any possibility to read in string format.
-
text is not readable formbharat– bharat2015-02-11 08:41:59 +00:00Commented Feb 11, 2015 at 8:41
Add a comment
|
1 Answer
Follow these steps in Oracle SQL Developer -
- Open data window of your table.
- The BLOB cell will be named as (BLOB).
- Right click the cell.
- You will see a pencil icon. Click on it.
- It will open a blob editor window.
- You would find two check boxes against the option View as : Image or Text.
- Select the appropriate check box.
- If above step is still convincing, then use the Download option.
Update
OP says "text is not understandable manner it is showing �� �� like this "
Probably, the locale-specific NLS characterset doesn't support those characters. It might also be that those are Multi-Byte characters. I would suggest, SPOOL the result to an HTML file, open it with your browser, you could view the content as most of the browsers are capable of displaying multiple charactersets.
You could do something like this from SQL*Plus -
SET MARKUP HTML ON SPOOL ON
SPOOL report.html
select substr(clob_column, 1, 32767) from table_name...
SPOOL OFF
Update 2
Regarding SPOOL as HTML, test case -
SET MARKUP HTML ON SPOOL ON
SPOOL D:\report.html
SELECT substr(ename, 1, 5) ename FROM emp where rownum <=5;
SPOOL OFF
Works perfectly for me, html file opens up with my browser, look at the screenshot -
12 Comments
Lalit Kumar B
What is readable format for you, please explain. I cannot address such a broad term.
Lalit Kumar B
What happens when you just do a
SUBSTR over the column? At least you can view the first 32767 characters.
bharat
text is not understandable manner it is showing �� �� like this
bharat
I am alredy using that substring query iam getting text like this ��srcom.hexgen.orm.PortfolioAlloc/���ZisActiveL_hexGenEntityVersiont3Lcom/hexgen/core/orm/basetypes/HexGenEntityVersion;L allocationPertLjava/math/BigDecimal;L
java-addict301
there is no pencil!
|