order by in view / search long field

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 ?
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 ! Received on Mon Jul 12 2004 - 10:54:25 CDT