Product specifications

To view and edit a function help text file...............................................................................158
12.4
To edit the help text for a PRM function...............................................................................158
12.5
PRM parameter reference...................................................................................................159Chapter 13
PRM file configuration reference..........................................................................................159
13.1
ANALYTIC_CLAUSE...........................................................................................................159
13.1.1
ANALYTIC_FUNCTIONS.....................................................................................................160
13.1.2
CONSTANT_SAMPLING_SUPPORTED..............................................................................160
13.1.3
DISTINCT............................................................................................................................161
13.1.4
EXT_JOIN............................................................................................................................161
13.1.5
FULL_EXT_JOIN..................................................................................................................162
13.1.6
GROUP_BY.........................................................................................................................162
13.1.7
GROUP_BY_SUPPORTS_COLUMN_INDEX......................................................................163
13.1.8
GROUP_BY_SUPPORTS_COMPLEX.................................................................................163
13.1.9
GROUP_BY_SUPPORTS_CONSTANT...............................................................................164
13.1.10
HAVING...............................................................................................................................164
13.1.11
INNER_JOIN........................................................................................................................165
13.1.12
INTERSECT.........................................................................................................................165
13.1.13
INTERSECT_ALL.................................................................................................................166
13.1.14
INTERSECT_IN_SUBQUERY...............................................................................................166
13.1.15
JOIN....................................................................................................................................166
13.1.16
LEFT_EXT_JOIN...................................................................................................................167
13.1.17
LEFT_OUTER.......................................................................................................................167
13.1.18
LIKE_SUPPORTS_ESCAPE_CLAUSE.................................................................................168
13.1.19
MINUS.................................................................................................................................168
13.1.20
MINUS_ALL........................................................................................................................169
13.1.21
MINUS_IN_SUBQUERY......................................................................................................169
13.1.22
ORDER_BY.........................................................................................................................170
13.1.23
ORDER_BY_REQUIRES_SELECT........................................................................................170
13.1.24
ORDER_BY_SUPPORTS_COLUMN_INDEX.......................................................................170
13.1.25
PERCENT_RANK_SUPPORTED..........................................................................................171
13.1.26
RANK_SUPPORTED...........................................................................................................171
13.1.27
RIGHT_EXT_JOIN................................................................................................................172
13.1.28
RIGHT_OUTER....................................................................................................................172
13.1.29
SEED_SAMPLING_SUPPORTED........................................................................................173
13.1.30
SELECT_SUPPORTS_NULL................................................................................................173
13.1.31
SUBQUERY_IN_FROM.......................................................................................................174
13.1.32
SUBQUERY_IN_IN..............................................................................................................174
13.1.33
SUBQUERY_IN_WHERE.....................................................................................................174
13.1.34
UNION.................................................................................................................................175
13.1.35
UNION_ALL.........................................................................................................................175
13.1.36
2012-03-159
Contents