Is there a SQL LIKE predicate selection operator for a Warehouse READ ?
The MATCH() function will provide what you want. To list all rows from the Oracle demo database’s EMP table where the EMP.JOB begins with “CL”, you can use the Warehouse MATCH() function to express the string matching you require. For example : 1> open db oracle scott/tiger 2> read x = db.emp for match(job,”CL*”) [Using serial read] 3> print x 4> endread 7369 SMITH CLERK 7902 17-DEC-1980 800.00 $NULL 20 7876 ADAMS CLERK 7788 23-MAY-1987 1100.00 $NULL 20 7900 JAMES CLERK 7698 03-DEC-1981 950.00 $NULL 30 7934 MILLER CLERK 7782 23-JAN-1982 1300.00 $NULL 10 The MATCH() function recognizes other special pattern characters. See the Warehouse Manual for details.
Related Questions
- Does Warehouse Builder have a published metadata model with SQL based query capability and/or an Application Program Interface (API)?
- In Hooked on Phonics Learn To Read I didn hear the question or the answer selection. How can I get it repeated?
- Is there a SQL LIKE predicate selection operator for a Warehouse READ ?
