Home / Middleware / Oracle Fusion Middleware Online Documentation Library, 11g Release 1 (11.1.1.5) / Develop Applications for Oracle Fusion Middleware
Complex Event Processing EPL Language Reference
ContentsOpens a new window
Opens a new window
Page 12 of 12

Index

AOpens a new window  BOpens a new window  COpens a new window  DOpens a new window  EOpens a new window  FOpens a new window  GOpens a new window  HOpens a new window  IOpens a new window  JOpens a new window  LOpens a new window  MOpens a new window  NOpens a new window  OOpens a new window  POpens a new window  QOpens a new window  ROpens a new window  SOpens a new window  TOpens a new window  UOpens a new window  WOpens a new window 

A

ABOpens a new window  AGOpens a new window  ANOpens a new window  APOpens a new window  AROpens a new window  AVOpens a new window 
about, 2.11Opens a new window
aggregate functions
about, 4.2Opens a new window
AVEDEV(ALL | DISTINCT), 4.2Opens a new window
AVG(ALL | DISTINCT), 4.2Opens a new window
COUNT(*), 4.2Opens a new window
COUNT(ALL | DISTINCT), 4.2Opens a new window
MAX(ALL | DISTINCT), 4.2Opens a new window
MEDIAN(ALL | DISTINCT), 4.2Opens a new window
MIN(ALL | DISTINCT), 4.2Opens a new window
STDDEV(ALL | DISTINCT), 4.2Opens a new window
SUM(ALL | DISTINCT), 4.2Opens a new window
TREND(expression), 4.2Opens a new window
aggregation, 1.3.5Opens a new window
AND operator
about, 2.5.2Opens a new window
API, 5.1Opens a new window
arithmetic operators, 3.2Opens a new window
array definition operators, 3.6Opens a new window
AVEDEV(ALL | DISTINCT) aggregate function
about, 4.2Opens a new window
AVG(ALL | DISTINCT) aggregate function
about, 4.2Opens a new window

B

BAOpens a new window  BEOpens a new window  BIOpens a new window 
BASED ON clause
about, 2.4.4.1Opens a new window
batched windows
about, 1.3.3Opens a new window
row-based, 1.3.3.2Opens a new window
time-based, 1.3.3.1Opens a new window
BETWEEN operator
about, 3.7.2Opens a new window
binary operators, 3.5Opens a new window

C

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

D

DAOpens a new window  DYOpens a new window 
datatypes
enum, 1.2.6Opens a new window
evaluating with functions, 1.2.6Opens a new window
other, 1.2.6Opens a new window
unsupported, 1.2.6Opens a new window
dynamic indexed event properties, 1.2.5Opens a new window
dynamic mapped event properties, 1.2.5Opens a new window
dynamic nested event properties, 1.2.5Opens a new window
dynamic simple event properties, 1.2.5Opens a new window

E

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

F

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

G

GROpens a new window 
GROUP BY clause
about, 2.7Opens a new window
HAVING clause, 2.8.1Opens a new window
OUTPUT clause, 2.10.1Opens a new window

H

HAOpens a new window 
HAVING clause
about, 2.8Opens a new window
GROUP BY clause, 2.8.1Opens a new window
MATCHING clause, 2.8.1Opens a new window
OUTPUT clause, 2.10.1Opens a new window
WHERE clause, 2.8.1Opens a new window

I

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

J

JOOpens a new window 
joins
inner, 2.3.1Opens a new window
outer, 2.3.2Opens a new window

L

LAOpens a new window  LIOpens a new window  LOOpens a new window 
LARGEST qualifier, 2.4.7Opens a new window
LIKE operator
about, 3.8.1Opens a new window
list operators, 3.7Opens a new window
logical operators, 3.3Opens a new window

M

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

N

NEOpens a new window  NOOpens a new window 
nested event properties, 1.2.4Opens a new window
NOT operator
about, 2.5.4Opens a new window

O

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

P

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

Q

QUOpens a new window 
qualifiers
LARGEST, 2.4.7Opens a new window
SMALLEST, 2.4.7Opens a new window
UNIQUE, 2.4.7Opens a new window
queries
parameterized, 2.13Opens a new window, 2.13.1Opens a new window

R

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

S

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

T

TEOpens a new window  TROpens a new window 
temporal operators, 3.9Opens a new window
TREND(expression) aggregate function
about, 4.2Opens a new window

U

UNOpens a new window  USOpens a new window 
UNIQUE qualifier, 2.4.7Opens a new window
use cases, 1.4Opens a new window
user-defined functions
about, 4.3Opens a new window

W

WHOpens a new window  WIOpens a new window 
WHERE clause
about, 1.3.4Opens a new window, 2.6Opens a new window
comparison operators, 2.6Opens a new window
HAVING clause, 2.8.1Opens a new window
WITH clause
about, 2.4.7Opens a new window
LARGEST, 2.4.7Opens a new window
SMALLEST, 2.4.7Opens a new window
UNIQUE, 2.4.7Opens a new window
WITHIN operator
about, 2.5.6Opens a new window, 3.9.2Opens a new window
Previous PageOpens a new window
Page 12 of 12
Next Page