|
const | SqlUtil::COP_APPEND = "append" |
| to append a string to a column on output More...
|
|
const | SqlUtil::COP_AS = "as" |
|
const | SqlUtil::COP_AVG = "avg" |
| to return the average value More...
|
|
const | SqlUtil::COP_CAST = "cast" |
| to convert column value into another datatype More...
|
|
const | SqlUtil::COP_COALESCE = "coalesce" |
| to return the first non-null argument in the list More...
|
|
const | SqlUtil::COP_COUNT = "count" |
| to return the row count More...
|
|
const | SqlUtil::COP_CUME_DIST = "cume_dist" |
| Analytic (window) function: CUME_DIST. More...
|
|
const | SqlUtil::COP_DENSE_RANK = "dense_rank" |
| Analytic (window) function: DENSE_RANK. More...
|
|
const | SqlUtil::COP_DISTINCT = "distinct" |
| to return distinct values More...
|
|
const | SqlUtil::COP_DIVIDE = "divide" |
| the SQL "divide" operator More...
|
|
const | SqlUtil::COP_FIRST_VALUE = "first_value" |
| Analytic (window) function: FIRST_VALUE. More...
|
|
const | SqlUtil::COP_LAST_VALUE = "last_value" |
| Analytic (window) function: LAST_VALUE. More...
|
|
const | SqlUtil::COP_LENGTH = "length" |
| to get the length of a text field More...
|
|
const | SqlUtil::COP_LOWER = "lower" |
| to return column value in lower case More...
|
|
const | SqlUtil::COP_MAX = "max" |
| to return the maximum value More...
|
|
const | SqlUtil::COP_MIN = "min" |
| to return the minimum value More...
|
|
const | SqlUtil::COP_MINUS = "minus" |
| the SQL "minus" operator More...
|
|
const | SqlUtil::COP_MULTIPLY = "multiply" |
| the SQL "multiply" operator More...
|
|
const | SqlUtil::COP_NTILE = "ntile" |
| Analytic (window) function: NTILE. More...
|
|
const | SqlUtil::COP_OVER = "over" |
| the SQL "over" clause More...
|
|
const | SqlUtil::COP_PERCENT_RANK = "percent_rank" |
| Analytic (window) function: PERCENT_RANK. More...
|
|
const | SqlUtil::COP_PLUS = "plus" |
| the SQL "plus" operator More...
|
|
const | SqlUtil::COP_PREPEND = "prepend" |
| to prepend a string to a column on output More...
|
|
const | SqlUtil::COP_RANK = "rank" |
| Analytic (window) function: RANK. More...
|
|
const | SqlUtil::COP_ROW_NUMBER = "row_number" |
| Analytic (window) function: ROW_NUMBER. More...
|
|
const | SqlUtil::COP_SEQ = "seq" |
| to return the next value of a sequence More...
|
|
const | SqlUtil::COP_SEQ_CURRVAL = "seq_currval" |
| to return the last value of a sequence issued in the same session More...
|
|
const | SqlUtil::COP_SUBSTR = "substr" |
| to extract a substring from a column More...
|
|
const | SqlUtil::COP_SUM = "sum" |
| to return the sum value More...
|
|
const | SqlUtil::COP_TRUNC_DATE = "truncate_date" |
| to return the date with truncated value More...
|
|
const | SqlUtil::COP_UPPER = "upper" |
| to return column value in upper case More...
|
|
const | SqlUtil::COP_VALUE = "value" |
| to append a constant value (SQL Literal) to use as an output column value More...
|
|
const | SqlUtil::COP_YEAR = "year" |
| to return a date value with year information only More...
|
|
const | SqlUtil::COP_YEAR_DAY = "year_day" |
| to return a date value with year to day information More...
|
|
const | SqlUtil::COP_YEAR_HOUR = "year_hour" |
| to return a date value with year to hextern information More...
|
|
const | SqlUtil::COP_YEAR_MONTH = "year_month" |
| to return a date value with year to month information More...
|
|
const | SqlUtil::DefaultCopMap = ... |
| a hash of default column operator descriptions
|
|