Re: order by in view / search long field

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