You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for match_recognize


1 to 20 of 48 results. Previous page Prev  Next next page
Results per page:   20  | 40


Database Data Warehousing Guide, 12c Release 1 (12.1)

SQL for Pattern Matching

Concatenated MATCH_RECOGNIZE ClauseNote that it is not prohibited to feed the output of one MATCH_RECOGNIZE clause into the input of … another, as in this example: SELECT... FROM ( SELECT * FROM Ticker MATCH_RECOGNIZE … (...) ) MATCH_RECOGNIZE (...) In this example, the first MATCH_RECOGNIZE clause is in a derived table, which then provides the input

Database Data Warehousing Guide, 12c Release 1 (12.1)

SQL for Pattern Matching

Prohibited Nesting in the MATCH_RECOGNIZE ClauseThe following kinds of nesting are prohibited in the MATCH_RECOGNIZE clause: Nesting one … MATCH_RECOGNIZE clause within another. Outer references in the MEASURES clause or the DEFINE subclause. This … means that a MATCH_RECOGNIZE clause cannot reference any table in an outer query block except the row … in MEASURES or DEFINE

Database JDBC Developer's Guide, 12c Release 1 (12.1)

JDBC Reference Information

MATCH_RECOGNIZE ClauseThe ? character is used as a token in MATCH_RECOGNIZE clause in Oracle Database 11 g and later … JDBC Driver, if you want to interpret the ? character as a MATCH_RECOGNIZE token and not as a … tkpattern_S11 \" + \"MATCH_RECOGNIZE ( \" + \" MEASURES A.c1 as firstW, last(Z.c1) as lastZ \" + \" ALL

Database Data Warehousing Guide, 12c Release 1 (12.1)

SQL for Pattern Matching

Rules and Restrictions in Pattern MatchingMatching Prohibited Nesting in the MATCH_RECOGNIZE Clause Concatenated MATCH_RECOGNIZE Clause Aggregate Restrictions

Database Data Warehousing Guide, 12c Release 1 (12.1)

SQL for Pattern Matching

Input Table Requirements in Pattern MatchingThe row pattern input table is the input argument to MATCH_RECOGNIZE. You can use a table or view … , SymbolNames S WHERE T.Symbol = S.Symbol) MATCH_RECOGNIZE (...) M The row pattern input table cannot be … * FROM A LEFT OUTER JOIN B ON (A.X = B.Y)) MATCH_RECOGNIZE (...) M Column names in the pattern input … D.Name, E.Name, E.Empno,

Database Data Warehousing Guide, 12c Release 1 (12.1)

SQL for Pattern Matching

ORDER BY: Logically Ordering the Rows in a PartitionMATCH_RECOGNIZE clause is non-deterministic: it may not give consistent results each time the query is run.

Database Data Warehousing Guide, 12c Release 1 (12.1)

SQL for Pattern Matching

Overview of Pattern Matching in Data WarehousesPattern matching in SQL is performed using the MATCH_RECOGNIZE clause. MATCH_RECOGNIZE enables you … MATCH_RECOGNIZE clause with its PARTITION BY and ORDER BY clauses. Define patterns of rows to seek using the … PATTERN clause of the MATCH_RECOGNIZE clause. These patterns use regular expression syntax, a powerful

Database Error Messages, 12c Release 1 (12.1)

ORA-60001 to ORA-65535

ORA-62519: Subquery inside MATCH_RECOGNIZE cannot contain MATCH_RECOGNIZE.Cause: An attempt was made to use a subquery containing a MATCH_RECOGNIZE clause inside a … MATCH_RECOGNIZE clause. Subqueries containing MATCH_RECOGNIZE clauses are currently not allowed in the … MATCH_RECOGNIZE clause. Action: Modify the query and retry the operation.

Database Data Warehousing Guide, 12c Release 1 (12.1)

Glossary

pattern matchingA way of recognizing patterns in a sequence of rows using the MATCH_RECOGNIZE clause.

Database SQL Language Reference, 12c Release 1 (12.1)

SELECT

Note on the WAIT and SKIP LOCKED Clauses… row_pattern_clause The MATCH_RECOGNIZE clause lets you perform pattern matching. Use this clause to recognize … a query that uses the MATCH_RECOGNIZE clause is called the row pattern output table. The … MATCH_RECOGNIZE enables you to do the following tasks: Logically partition and order the data with the

Database Error Messages, 12c Release 1 (12.1)

ORA-60001 to ORA-65535

ORA-62518: MATCH_RECOGNIZE pattern is too large.Cause: MATCH_RECOGNIZE pattern was too large. More than UB2MAXVAL elements in alternation

Database Error Messages, 12c Release 1 (12.1)

QSM-00501 to QSM-03287

QSM-02209: a MATCH_RECOGNIZE clause is presentMATCH_RECOGNIZE clause. Action: Remove the MATCH_RECOGNIZE clause.

Database Data Warehousing Guide, 12c Release 1 (12.1)

SQL for Pattern Matching

20 SQL for Pattern MatchingMATCH_RECOGNIZE clause to achieve this capability in native SQL that executes efficiently. This chapter

Database Data Warehousing Guide, 12c Release 1 (12.1)

SQL for Pattern Matching

Advanced Topics in Pattern Matchingoutput table, similar to the following: SELECT M.Matchno FROM Ticker MATCH_RECOGNIZE (... MEASURE

Database Data Warehousing Guide, 12c Release 1 (12.1)

SQL for Pattern Matching

[ONE ROW | ALL ROWS] PER MATCH: Choosing Summaries or Details for Each Matchmatch. The output is explained in \" Row Pattern Output \". The MATCH_RECOGNIZE clause may find a

Database Error Messages, 12c Release 1 (12.1)

ORA-60001 to ORA-65535

ORA-62506: illegal nesting of operators in MATCH_RECOGNIZE clauseCause: An attempt was made to nest aggregates/FIRST/LAST/PREV/NEXT. Aggregates/FIRST/LAST/PREV/NEXT cannot be nested. The only exception allowed is PREV/NEXT(FIRST/LAST()). Action: Modify the query and retry the operation.

Database Error Messages, 12c Release 1 (12.1)

ORA-60001 to ORA-65535

ORA-62510: Correlated subqueries are not allowed in MATCH_RECOGNIZE clause.Cause: An attempt was made to use correlated subqueries in the MATCH_RECOGNIZE clause. Correlated … subqueries are currently not allowed in the MATCH_RECOGNIZE clause. Action: Modify the query and retry the operation.

Database Error Messages, 12c Release 1 (12.1)

ORA-60001 to ORA-65535

ORA-62500: function is not allowed outside of MATCH_RECOGNIZE clauseCause: The function was specified outside of the MATCH_RECOGNIZE clause. This function is only … allowed in the MATCH_RECOGNIZE clause. Action: Rewrite the SQL statement.

Database Error Messages, 12c Release 1 (12.1)

ORA-60001 to ORA-65535

ORA-62520: illegal offset for MATCH_RECOGNIZE navigation operatorsfor MATCH_RECOGNIZE navigation operators FIRST, LAST, PREV, or NEXT. Offset for MATCH_RECOGNIZE

Database Error Messages, 12c Release 1 (12.1)

ORA-60001 to ORA-65535

ORA-62511: Correlation variables are not allowed in MATCH_RECOGNIZE clause.Cause: An attempt was made to use correlation variables in the MATCH_RECOGNIZE clause. Correlation … variables are currently not allowed in the MATCH_RECOGNIZE clause. Action: Modify the query and retry the operation.