MatchedCols Function


the matchedCols of <dataSheet>
where "condition" Applies to datasheets


The matchedCols function is a query function that returns a comma-delimited list of numbers that correspond to the columns of a dataSheet that satisfy the given constraints. The constraints are specified using a string expression. You can use several constraints joined by logical operators. Each constraint must use the following format: [not] <row> [= | > | < | etc.] value


You can use the matchedCols function to find matching data with spaces in it. For example, into selectedColVar Row 2 will be searched for values that are greater than Smith and row 5 will be searched for values greater than 32000. The resulting string of matching column numbers will be put into the variable selectedColVar.
This text has been mechanically extracted from the Oracle Media Objects MediaTalk Reference, © 1995 Oracle Corporation, and is provided here solely for educational/historical purposes.