Re: order by in view / search long field

On 12 Jul 2004 08:54:25 -0700, blx999_at_gmx.de (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 ?
>

It should be possible now. Of course you could look this up in the sql reference manual.

>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
>
>any hint would be nice !

As per your requirements no types are suitable. You should review your requirements.

--
Sybrand Bakker, Senior Oracle DBA