QUERY FOR BLOB OR CLOB datatype URGENT

From: Sanjay Kumar <ora_user_at_hotmail.com>
Date: Thu, 28 Sep 2000 15:51:49 -0700
Message-Id: <10633.118191@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_000B_01C02964.0313EDC0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I have a blob and a clob datatype in two separate tables. I want to = issue a query with the where clause for the blob datatype. Is it = possible?=20

I know that in SQL PLUS U cant do it. I am using Java as the front end. All I want to know is whether the below query is possible or not.

Select * from <table> where <blob/clob datatype> =3D 'xxxxxxxxxxxxx';

If not possible, then what is the alternative? TIA Sanjay Kumar

------=_NextPart_000_000B_01C02964.0313EDC0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have a blob and a clob datatype in =
two separate=20
tables. I want to issue a query with the where clause for the blob = datatype. Is=20
it possible? </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I know that in SQL PLUS U cant do it. I =
am using=20
Java as the front end.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>All I want to know is whether the below =
query is=20
possible or not.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Select * from <table> where =
<blob/clob=20
datatype> =3D 'xxxxxxxxxxxxx';</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>If not possible, then what is the=20
alternative?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>TIA</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Sanjay Kumar</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
Received on Thu Sep 28 2000 - 17:51:49 CDT