Re: SQL and Long

Ok

you cannot use Long datatype with like operator and more over you cannot use long Datatype in where , Distinct , order by ,group by clauses.

so add a new column in your table and assign a Unique number( you can use sequence )for each Long row , and do searching on that unique Number.

Faheem Rao

siva_kb_at_yahoo.co.uk (Kishan) wrote in message news:<1ef7633f.0109270239.5a608e72_at_posting.google.com>...
> "Fons Reijsbergen" <fons.reijsbergen_at_kb.nl> wrote in message news:<9osmb1$d5m$1_at_news.surfnet.nl>...
> > Hello,
> >
> > I have a small problem. I have created the next table
> >
> > CREATE TABLE FICHESGMLS
> > (FICHEID CHAR(12) NOT NULL,
> > SGML LONG NOT NULL,
> > PRIMARY KEY (FICHEID));
> >
> > I have the next query:
> >
> > Select * from FICHESGMLS where SGML like '%rome%';
> > I get the error: ORA-00932: Inconsistent datatypes.
> > or
> > Select * from FICHESGMLS where SGML = 'Rome';
> > the error: ORA-00997: Illegal use of LONG datatype.
> >
> > does this mean that I can not search in the Long datafield?
> > And if so what must I do to do the job.
> >
> >
> > Thanks in advance
> > Fons Reijsbergen
> >
> > fons.reijsbergen_at_kb.nl
>
>
> I don't know what version of Oracle you're using. In Oracle 8.x, you
> can create LOB (Large OBject) datatypes such as BLOB, CLOB, BFILE or
> NCLOB datatypes. Manipultion of LOBs can be done using DBMS_LOB
> package. Hope it helps.
Received on Sat Sep 29 2001 - 00:57:30 CEST