I hope the question is pertaining to using long column in where clause.
Try this
-
declare
cursor c0 is
select view_name,text
from user_views;
Cview_name varchar2(30);
Ltextlong;
begin
open c0;
loop
fetch c0
Title: RE: How to select data from a LONG datatype
Ketan,
CONTAINS() is an Intermedia operator and will blow an error if no Intermedia index exists on the column that is indexed.
Rodd, unfortunately I think you'll have to resort to PL/SQL. You'd have to split the LONG field into the 32K
How do I get past the inconsistent datatypes error on the following?
select *
from dba_views
where owner = 'SA'
andtext like '%/*%';
We have some views that were migrated from 7.3.4 to 8.0.5 and we suspect
that we
lost our hints in the migration and upgrade. I want to find which views
Hi,
For long data type in selection use contains instead
of like. Before this set environment for sql*plus like
set long 5000 .
--- Rodd Holman [EMAIL PROTECTED] wrote:
How do I get past the inconsistent datatypes error
on the following?
select *
from dba_views
where owner = 'SA'
Ketan Patel wrote:
Hi,
For long data type in selection use contains instead
of like. Before this set environment for sql*plus like
set long 5000 .
--- Rodd Holman [EMAIL PROTECTED] wrote:
How do I get past the inconsistent datatypes error
on the following?
select *
from