Message-Id: <10633.118191@fatcity.com> From: "Sanjay Kumar" Date: Thu, 28 Sep 2000 15:51:49 -0700 Subject: QUERY FOR BLOB OR CLOB datatype URGENT 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 where =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

Hi,

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?

I know that in SQL PLUS U cant do it. I = am using=20 Java as the front end.

All I want to know is whether the below = query is=20 possible or not.

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

If not possible, then what is the=20 alternative?

TIA

Sanjay Kumar