Skip Headers
Oracle® CEP EPL Language Reference
Release 11gR1 (11.1.1)
Part Number E14304-01
Home
Book List
Index
Contact Us
Next
View PDF
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Overview of the Event Processing Language (EPL)
1.1
Overview of the EPL Language
1.2
Event Representation
1.2.1
Event Objects
1.2.2
Plain Old Java Object Events
1.2.3
Map Events
1.2.4
Event Properties
1.2.5
Dynamic Event Properties
1.2.6
Handling Other Event Properties Using a User-Defined Function
1.2.7
Event Sinks
1.3
Processing Model
1.3.1
Event Streams
1.3.2
Sliding Windows
1.3.2.1
Row-Based Sliding Windows
1.3.2.2
Time-Based Sliding Windows
1.3.3
Batched Windows
1.3.3.1
Time-Based Batched Windows
1.3.3.2
Row-Based Batched Windows
1.3.4
Subqueries and WHERE Clauses
1.3.5
Aggregation
1.4
Use Cases
1.4.1
Computing Rates per Feed
1.4.2
Computing Highest Priced Stocks
1.4.3
Segmenting Location Data
1.4.4
Detecting Rapid Fall-off
1.4.5
Finding Network Anomalies
1.4.6
Detecting Absence of Event
1.4.7
Summarizing Terminal Activity Data
1.4.8
Reading Sensor Data
1.4.9
Combining Transaction Events
1.4.10
Monitoring Real-time Performance
1.4.11
Finding Dropped Transaction Events
2
EPL Reference: Clauses
2.1
Overview of the Clauses You Can Use in an EPL Statement
2.2
SELECT
2.2.1
Choosing Specific Event Properties
2.2.2
Using Expressions
2.2.3
Aliasing Event Properties
2.2.4
Choosing All Event Properties
2.2.5
Selecting New and Old Events With ISTREAM and RSTREAM Keywords
2.3
FROM
2.3.1
Inner Joins
2.3.2
Outer Joins
2.3.3
Subquery Expressions
2.3.4
Parameterized SQL Queries
2.4
RETAIN
2.4.1
Keeping All Events
2.4.2
Specifying Window Size
2.4.3
Specifying Batched Versus Sliding Windows
2.4.4
Specifying Time Interval
2.4.4.1
BASED ON Clause
2.4.5
Specifying Property Name
2.4.6
Using PARTION BY Clause to Partition Window
2.4.7
Using WITH Clause to Keep Largest/Smallest/Unique Values
2.5
MATCHING
2.5.1
FOLLOWED BY Operator
2.5.2
AND Operator
2.5.3
OR Operator
2.5.4
NOT Operator
2.5.5
EVERY Operator
2.5.6
WITHIN Operator
2.5.7
Event Structure for Matched Pattern
2.6
WHERE
2.7
GROUP BY
2.8
HAVING
2.8.1
Interaction With MATCHING, WHERE and GROUP BY Clauses
2.9
ORDER BY
2.10
OUTPUT
2.10.1
Interaction With GROUP BY and HAVING Clauses
2.11
INSERT INTO
2.12
Simple and Correlated Subqueries
2.13
Parameterized Queries
2.13.1
General Usage
2.13.2
Using a Parameterized EPL Statement in the Processor Configuration File
2.13.3
Programmatically Using a Prepared EPL Statement
3
EPL Reference: Operators
3.1
Overview of EPL Operators
3.2
Arithmetic Operators
3.3
Logical and Comparison Operators
3.4
Concatenation Operators
3.5
Binary Operators
3.6
Array Definition Operator
3.7
List and Range Operators
3.7.1
IN Operator
3.7.2
BETWEEN Operator
3.8
String Operators
3.8.1
LIKE Operator
3.8.2
REGEXP Operator
3.9
Temporal Operators
3.9.1
FOLLOWED BY Operator
3.9.2
WITHIN Operator
3.9.3
EVERY Operator
4
EPL Reference: Functions
4.1
Single-row Functions
4.1.1
The MIN and MAX Functions
4.1.2
The COALESCE Function
4.1.3
The CASE Control Flow Function
4.1.4
The PREV Function
4.1.4.1
Previous Event Per Group
4.1.4.2
Restrictions
4.1.5
The PRIOR Function
4.1.5.1
Comparison to the PREV Function
4.1.6
The INSTANCEOF Function
4.1.7
The CAST Function
4.1.8
The EXISTS Function
4.2
Aggregate functions
4.3
User-Defined functions
5
Programmatic Interface to EPL
5.1
Java Programming Interfaces
Index
Scripting on this page enhances content navigation, but does not change the content in any way.