SQL functions with LOBs as arguments, except functions that compare LOB values, are allowed in predicates of the WHERE clause.
The LENGTH function can be included in the predicate of the WHERE clause :.