Re: order by in view / search long field

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1089688280.610487_at_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.

well, you are right, creating a view with order by included works from the sql-plus-worksheet, it does not work from the Enterprise Manager Console.

>
> But why you are working with 9.2.0.1 is a mystery.
>

the version is taken from the release notes, what do you feel 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

thank you for your answers ! Received on Fri Jul 16 2004 - 11:07:07 CDT