Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: order by in view / search long field

Re: order by in view / search long field

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 12 Jul 2004 20:11:04 -0700
Message-ID: <1089688280.610487@yasure>


freak wrote:
> hi
>
> i have two questions that seem to have been asked several times
> before, but i am not clear about teh answers :
>
> 1. i am using Oracle Release 2 (9.2.0.1.0) for Windows. from some news
> i read that in older versions it was not possible to use ORDER BY in
> views, and it seems to me that it is still not possible, am i right in
> this point ?

Incorrect. ORDER BY works with views in 9i and above.

But why you are working with 9.2.0.1 is a mystery.

> 2. the problem of converting mssql-text-fields to oracle.long looks
> like a common one. so my question is: what type is best used in oracle
> as an equivalent to the mssql-text-type ? it must be searchable and
> not be a LOB. i have also tried to cast values from a long field to a
> varray, but did not succeed :
>
> select * from USER_LOTTO.abo_beitrag where CAST(beitragtext AS
> VARCHAR2(4000)) like 'test'
> throws :
> FEHLER in Zeile 1:
> ORA-00932: nicht übereinstimmende Datentypen

CLOB. Oracle has already announced that you should not use LONG.

> any hint would be nice !

Daniel Morgan Received on Mon Jul 12 2004 - 22:11:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US