Re: QUERY FOR BLOB OR CLOB datatype URGENT

Hi,
Thanks for the reponse. Actually, my question is I would like to include the blob/clob datatype in the where clause of the Query. Any help greatly appreciated.

Sanjay Kumar

• Original Message ----- From: "Parekh, Ketan" <KParekh_at_ea.com> To: "'Sanjay Kumar'" <ora_user_at_hotmail.com> Sent: Friday, September 29, 2000 6:45 AM Subject: RE: QUERY FOR BLOB OR CLOB datatype URGENT

> Hi! Sanjay,
>
> I am also in the same situation - what I do is check the length of the
field
> which is a blob : -
> check the below procedure : -
>
> declare
> x number ;
> cursor c1 is select * from test_lobs;
> begin
> for a in c1
> loop
> x := dbms_lob.getlength(a.c4); // c4 is the column name
> dbms_output.put_line('Lenght = '||x);
> end loop;
> end;
>
> hope this helps
>
> Ketan
>
>
> -----Original Message-----
>
> From: Sanjay Kumar [mailto:ora_user_at_hotmail.com]
> Sent: Thursday, September 28, 2000 6:52 PM
> To: Oracle Discussion List; Oracle List (Telelist)
> Subject: QUERY FOR BLOB OR CLOB datatype URGENT
>
>
> 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?
>
> 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> = 'xxxxxxxxxxxxx';
>
> If not possible, then what is the alternative?
Received on Fri Sep 29 2000 - 11:30:12 CDT