Skip Headers
Oracle® Fusion Middleware EPL Language Reference for Oracle Complex Event Processing
11g Release 1 (11.1.1.6.3)

Part Number E14304-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  G  H  I  J  L  M  N  O  P  Q  R  S  T  U  W 

A

about, 2.11
aggregate functions
about, 4.2
AVEDEV(ALL | DISTINCT), 4.2
AVG(ALL | DISTINCT), 4.2
COUNT(*), 4.2
COUNT(ALL | DISTINCT), 4.2
MAX(ALL | DISTINCT), 4.2
MEDIAN(ALL | DISTINCT), 4.2
MIN(ALL | DISTINCT), 4.2
STDDEV(ALL | DISTINCT), 4.2
SUM(ALL | DISTINCT), 4.2
TREND(expression), 4.2
aggregation, 1.3.5
AND operator
about, 2.5.2
API, 5.1
arithmetic operators, 3.2
array definition operators, 3.6
AVEDEV(ALL | DISTINCT) aggregate function
about, 4.2
AVG(ALL | DISTINCT) aggregate function
about, 4.2

B

BASED ON clause
about, 2.4.4.1
batched windows
about, 1.3.3
row-based, 1.3.3.2
time-based, 1.3.3.1
BETWEEN operator
about, 3.7.2
binary operators, 3.5

C

CASE single-row function
about, 4.1.3
CAST single-row function
about, 4.1.7
clauses
about, 2.1
BASED ON, 2.4.4.1
correlated subqueries, 2.12
FROM, 2.3
GROUP BY, 2.7
HAVING, 2.8
INSERT INTO, 1.1, 2.3.4, 2.11
MATCHING, 1.1, 2.5
ORDER BY, 2.9
OUTPUT, 1.1, 2.10
parameterized queries, 2.13, 2.13.1
PARTITION BY, 2.4.6
RETAIN, 2.4
RETAINING, 1.1
SELECT, 2.2
simple subqueries, 2.12
WHERE, 1.3.4, 2.6
WITH, 2.4.7
COALESCE single-row function
about, 4.1.2
comparison operators, 2.6, 3.3
comparison to SQL, 1.1
concatenation operators, 3.4
correlated subqueries, 2.12
COUNT(*) aggregate function
about, 4.2
COUNT(ALL | DISTINCT) aggregate function
about, 4.2

D

datatypes
enum, 1.2.6
evaluating with functions, 1.2.6
other, 1.2.6
unsupported, 1.2.6
dynamic indexed event properties, 1.2.5
dynamic mapped event properties, 1.2.5
dynamic nested event properties, 1.2.5
dynamic simple event properties, 1.2.5

E

enum datatypes, 1.2.6
EPL
API, 5.1
EPL statements
prepared, 2.13.3
event objects, 1.2.1
Event Processing Language. See EPL
event properties
about, 1.2.4
aliases, 2.2.3
dynamic, 1.2.5
dynamic indexed, 1.2.5
dynamic mapped, 1.2.5
dynamic nested, 1.2.5
dynamic simple, 1.2.5
indexed, 1.2.4
mapped, 1.2.4
nested, 1.2.4
other, 1.2.6
SELECT clause, 2.2.3
simple, 1.2.4
event representation
about, 1.1, 1.2
event objects, 1.2.1
Map events, 1.2.3
POJO, 1.2.2
properties, 1.2.4, 1.2.5
event sinks
about, 1.2.7
ISTREAM events, 1.2.7
RSTREAM events, 1.2.7
event streams, 1.3.1
EVERY operator
about, 2.5.5, 3.9.3
EXISTS single-row function
about, 4.1.8

F

FOLLOWED BY operator
about, 2.5.1, 3.9.1
FROM clause
about, 2.3
joins
inner, 2.3.1
outer, 2.3.2
parameterized SQL queries, 2.3.4
subquery expressions, 2.3.3
functions
aggregate, 4.2
single-row, 4.1
user-defined, 4.3

G

GROUP BY clause
about, 2.7
HAVING clause, 2.8.1
OUTPUT clause, 2.10.1

H

HAVING clause
about, 2.8
GROUP BY clause, 2.8.1
MATCHING clause, 2.8.1
OUTPUT clause, 2.10.1
WHERE clause, 2.8.1

I

IN operator
about, 3.7.1
indexed event properties, 1.2.4
INSERT INTO clause, 2.11
about, 1.1
parameterized SQL queries, 2.3.4
INSTANCE OF single-row function
about, 4.1.6
IS NOT NULL operator, 2.6
IS NULL operator, 2.6
ISTREAM
SELECT clause, 2.2.5
ISTREAM events, 1.2.7

J

joins
inner, 2.3.1
outer, 2.3.2

L

LARGEST qualifier, 2.4.7
LIKE operator
about, 3.8.1
list operators, 3.7
logical operators, 3.3

M

Map events, 1.2.3
mapped event properties, 1.2.4
MATCHING clause
about, 1.1, 2.5
AND operator, 2.5.2
event structure for matched pattern, 2.5.7
EVERY operator, 2.5.5
FOLLOWED BY operator, 2.5.1
HAVING clause, 2.8.1
matched pattern, 2.5.7
NOT operator, 2.5.4
OR operator, 2.5.3
WITHIN operator, 2.5.6
MAX single-row function
about, 4.1.1
MAX(ALL | DISTINCT) aggregate function
about, 4.2
MEDIAN(ALL | DISTINCT) aggregate function
about, 4.2
MIN single-row function
about, 4.1.1
MIN(ALL | DISTINCT) aggregate function
about, 4.2

N

nested event properties, 1.2.4
NOT operator
about, 2.5.4

O

operators
about, 3.1
AND, 2.5.2
arithmetic, 3.2
array definition, 3.6
BETWEEN, 3.7.2
binary, 3.5
comparison, 2.6, 3.3
concatenation, 3.4
EVERY, 2.5.5, 3.9.3
FOLLOWED BY, 2.5.1, 3.9.1
IN, 3.7.1
IS NOT NULL, 2.6
IS NULL, 2.6
LIKE, 3.8.1
list, 3.7
logical, 3.3
NOT, 2.5.4
OR, 2.5.3
range, 3.7
REGEXP, 3.8.2
string, 3.8
temporal, 3.9
WITHIN, 2.5.6, 3.9.2
OR operator
about, 2.5.3
ORDER BY clause
about, 2.9
OUTPUT clause
about, 1.1, 2.10
GROUP BY clause, 2.10.1
HAVING clause, 2.10.1

P

paramaterized SQL queries, 2.3.4
parameterized queries
about, 2.13, 2.13.1
prepared EPL statment, 2.13.3
processor component configuration file, 2.13.2
PARTITION BY clause
about, 2.4.6
Plain Old Java Object. See POJO
POJO
event representation, 1.2.2
PREV single-row function
about, 4.1.4
per group, 4.1.4.1
PRIOR single-row function, 4.1.5.1
restrictions, 4.1.4.2
PRIOR single-row function
about, 4.1.5
PREV single-row function, 4.1.5.1
processing model
about, 1.1, 1.3
aggregation, 1.3.5
batched windows
about, 1.3.3
row-based, 1.3.3.2
time-based, 1.3.3.1
event streams, 1.3.1
sliding windows
about, 1.3.2
row-based, 1.3.2.1
time-based, 1.3.2.2
subqueries, 1.3.4
use cases, 1.4
programmatic interface, 1.1

Q

qualifiers
LARGEST, 2.4.7
SMALLEST, 2.4.7
UNIQUE, 2.4.7
queries
parameterized, 2.13, 2.13.1

R

range operators, 3.7
REGEXP operator
about, 3.8.2
RETAIN clause
about, 2.4
BASED ON clause, 2.4.4.1
batched and sliding windows, 2.4.3
keeping all events, 2.4.1
PARTITION BY clause, 2.4.6
property name, 2.4.5
sliding window size, 2.4.2
time interval, 2.4.4
WITH clause, 2.4.7
RETAINING clause
about, 1.1
RSTREAM
SELECT clause, 2.2.5
RSTREAM events, 1.2.7

S

SELECT clause
about, 2.2
aliasing event properties, 2.2.3
choosing all event properties, 2.2.4
choosing event properties, 2.2.1
expressions, 2.2.2
ISTREAM, 2.2.5
RSTREAM, 2.2.5
selecting new events, 2.2.5
selecting old events, 2.2.5
simple event properties, 1.2.4
simple subqueries, 2.12
single-row functions
about, 4.1
CASE, 4.1.3
CAST, 4.1.7
COALESCE, 4.1.2
EXISTS, 4.1.8
INSTANCE OF, 4.1.6
MAX, 4.1.1
MIN, 4.1.1
PREV, 4.1.4
PRIOR, 4.1.5, 4.1.5.1
sliding windows
about, 1.3.2
RETAIN clause, 2.4.2
row-based, 1.3.2.1
size, 2.4.2
time-based, 1.3.2.2
SMALLEST qualifier, 2.4.7
SQL comparison, 1.1
SQL queries, 2.3.4
STDDEV(ALL | DISTINCT) aggregate function
about, 4.2
streams, 1.3.1
string operators, 3.8
sub-queries, 1.3.4
correlated, 2.12
FROM clause, 2.3.3
paramaterized SQL queries, 2.3.4
simple, 2.12
SUM(ALL | DISTINCT) aggregate function
about, 4.2

T

temporal operators, 3.9
TREND(expression) aggregate function
about, 4.2

U

UNIQUE qualifier, 2.4.7
use cases, 1.4
user-defined functions
about, 4.3

W

WHERE clause
about, 1.3.4, 2.6
comparison operators, 2.6
HAVING clause, 2.8.1
WITH clause
about, 2.4.7
LARGEST, 2.4.7
SMALLEST, 2.4.7
UNIQUE, 2.4.7
WITHIN operator
about, 2.5.6, 3.9.2