How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Jump to Concatenated MATCH_RECOGNIZE Clause → Note 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
Jump to Prohibited Nesting in the MATCH_RECOGNIZE Clause → The following kinds of nesting are prohibited in the MATCH_RECOGNIZE clause: Nesting one … MATCH_RECOGNIZE clause within another. Outer references in the MEASURES
Jump to MATCH_RECOGNIZE Clause → The ? 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
Jump to Rules and Restrictions in Pattern Matching → Nesting in the MATCH_RECOGNIZE Clause Concatenated MATCH_RECOGNIZE Clause Aggregate Restrictions
Jump to row_pattern_partition_by → row_pattern_clause The MATCH_RECOGNIZE clause lets you perform pattern matching. Use this clause to … . The result of a query that uses the MATCH_RECOGNIZE clause
Jump to Overview of Pattern Matching → Pattern matching in SQL is performed using the MATCH_RECOGNIZE clause. MATCH_RECOGNIZE enables you … MATCH_RECOGNIZE clause with its PARTITION
Jump to Input Table Requirements → The 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
Jump to 184.108.40.206 Native SQL Support for Row Pattern Matching → The MATCH_RECOGNIZE clause enables native SQL queries to match specified patterns in sequences of … can benefit from MATCH_RECOGNIZE. See Also: Oracle Database
Jump to ORDER BY: Logically Ordering the Rows in a Partition → MATCH_RECOGNIZE clause is non-deterministic: it may not give consistent results each time the query is run.
Jump to Row Pattern Matching: Example → ONE ROW PER MATCH, and three matches were found. SELECT * FROM Ticker MATCH_RECOGNIZE ( PARTITION
Jump to pattern matching → A way of recognizing patterns in a sequence of rows using the MATCH_RECOGNIZE clause.
Jump to 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
Jump to 20 SQL for Pattern Matching → MATCH_RECOGNIZE clause to achieve this capability in native SQL that executes efficiently. This chapter
Jump to Correlation Name and Row Pattern Output → : SELECT M.Matchno FROM Ticker MATCH_RECOGNIZE (... MEASURE MATCH_NUMBER() AS Matchno... ) M In the
Jump to ORA-62518: MATCH_RECOGNIZE pattern is too large. → Cause: MATCH_RECOGNIZE pattern was too large. More than UB2MAXVAL elements in alternation
Jump to QSM-02209: a MATCH_RECOGNIZE clause is present → MATCH_RECOGNIZE clause. Action: Remove the MATCH_RECOGNIZE clause.
Jump to [ONE ROW | ALL ROWS] PER MATCH: Choosing Summaries or Details for Each Match → match. The output is explained in "Row Pattern Output". The MATCH_RECOGNIZE clause may find a match
Jump to Example 20-20 Simple Sessionization with Aggregation → MATCH_RECOGNIZE (PARTITION BY User_ID ORDER BY Time_Stamp MEASURES MATCH_NUMBER() session_id, COUNT(*) AS
Jump to Example 20-6 Defining Pattern Variables → SELECT * FROM Ticker MATCH_RECOGNIZE ( PARTITION BY Symbol FROM Ticker MATCH_RECOGNIZE ( PARTITION
Jump to Example 20-22 Suspicious Money Transfer → event = 'transfer') MATCH_RECOGNIZE (PARTITION BY userid ORDER BY time MEASURES FIRST(x.time) first_t … WHERE event = 'transfer') MATCH_RECOGNIZE (PARTITION BY