To paste a function into a condition:
Suppose you want to list the names of all customers whose names are more than 30 characters long because these names are too long for your mailing labels. To list these names, you create a condition using the LENGTH function. LENGTH counts the number of characters in a character string.
In this example, the argument in the LENGTH function is the NAME column in the customer table. So your function appears in the condition as:
LENGTH (NAME) > 30
Using this condition, Query Builder will evaluate all names in the NAME column and return those where the length of the field is greater than 30 characters.
About conditions (Query Builder)
Adding conditions to a query (Query Builder)
Condition syntax (Query Builder)
Controlling join conditions in linked queries (Query Builder)
Creating a negating condition (Query Builder)
Creating a nested condition (Query Builder)
Copyright © 1984, 2005, Oracle. All rights reserved.