You can use interMedia Text Editor utility from Oracle 7.3 onwards to use LONG field in Where clause of the sql statement.See the documentation on interMedia