BLOB Query in Oracle database

Posted on 2010-01-11
Medium Priority
Last Modified: 2013-12-18

I have a Oracle table with a BLOB field. It is a XML format.

I tried to find any record with <Answer> is null which means they don't provide answer?

    <Answer id='1''></Answer>
    <Answer id='2' ></Answer>

Can i do it via query? Or i need to write Java program to read it?

Question by:idmdeveloper
LVL 15

Accepted Solution

Shaju Kumbalath earned 2000 total points
ID: 26289955
First  convert BLOB to CLOB using DBMS_LOB.CONVERTTOCLOB, then used EXTRACT function of XMLTYPE to get the values from XML file.

Author Comment

ID: 26478336
Thanks for your help

Featured Post

2017 Webroot Threat Report

MSPs: Get the facts you need to protect your clients.
The 2017 Webroot Threat Report provides a uniquely insightful global view into the analysis and discoveries made by the Webroot® Threat Intelligence Platform to provide insights on key trends and risks as seen by our users.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Our Group Policy work started with Small Business Server in 2000. Microsoft gave us an excellent OU and GPO model in subsequent SBS editions that utilized WMI filters, OU linking, and VBS scripts. These are some of experiences plus our spending a lo…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
Suggested Courses
Course of the Month12 days, 23 hours left to enroll

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question