manipulate long datatype
From: ~{bR6!~} <cook_l_at_hotmail.com>
Date: Fri, 8 May 1998 08:58:28 +0800
Message-ID: <6itlgs$s86$1_at_www.clinux.ml.org>
Hi,
i have question about long datatype, it can't be use in where clause, but i want to find specific word in a long
datatype. for example:
select * from test_table where test like '%demo%' if "test" is varchar2 datatype, it's no problem. if it's long datatype, it can't work.
So what can i do? Can i use another method to implement it. Help me.
thank u very much.
Cook Received on Fri May 08 1998 - 02:58:28 CEST
Date: Fri, 8 May 1998 08:58:28 +0800
Message-ID: <6itlgs$s86$1_at_www.clinux.ml.org>
Hi,
i have question about long datatype, it can't be use in where clause, but i want to find specific word in a long
datatype. for example:
select * from test_table where test like '%demo%' if "test" is varchar2 datatype, it's no problem. if it's long datatype, it can't work.
So what can i do? Can i use another method to implement it. Help me.
thank u very much.
Cook Received on Fri May 08 1998 - 02:58:28 CEST