When would isSearchable return false for an Oracle JDBC column?

Posted by Ian Varley on Stack Overflow See other posts from Stack Overflow or by Ian Varley
Published on 2010-06-01T17:59:12Z Indexed on 2010/06/01 18:03 UTC
Read the original article Hit count: 186

Filed under:
|
|

In what cases would a call to java.sql.ResultSetMetaData.isSearchable(int col) return false for an Oracle database? The documentation for the method doesn't really answer the question:

"Indicates whether the designated column can be used in a where clause."

I can think of only one case - when the column is the result of an aggregate function (in which case it would have to be part of a HAVING filter, not a WHERE filter).

Are there any other cases?

© Stack Overflow or respective owner

Related posts about sql

Related posts about Oracle