Classes
hashdecl	SqlUtil::QueryInfo
	Query information. More...

Variables
const	SqlUtil::COP_APPEND = "append"
	to append a string to a column on output

const	SqlUtil::COP_AS = "as"

const	SqlUtil::COP_AVG = "avg"
	to return the average value

const	SqlUtil::COP_CAST = "cast"
	to convert column value into another datatype

const	SqlUtil::COP_COALESCE = "coalesce"
	to return the first non-null argument in the list

const	SqlUtil::COP_COUNT = "count"
	to return the row count

const	SqlUtil::COP_CUME_DIST = "cume_dist"
	Analytic (window) function: CUME_DIST.

const	SqlUtil::COP_DENSE_RANK = "dense_rank"
	Analytic (window) function: DENSE_RANK.

const	SqlUtil::COP_DISTINCT = "distinct"
	to return distinct values

const	SqlUtil::COP_DIVIDE = "divide"
	the SQL `"divide"` operator

const	SqlUtil::COP_FIRST_VALUE = "first_value"
	Analytic (window) function: FIRST_VALUE.

const	SqlUtil::COP_LAST_VALUE = "last_value"
	Analytic (window) function: LAST_VALUE.

const	SqlUtil::COP_LENGTH = "length"
	to get the length of a text field

const	SqlUtil::COP_LOWER = "lower"
	to return column value in lower case

const	SqlUtil::COP_MAX = "max"
	to return the maximum value

const	SqlUtil::COP_MIN = "min"
	to return the minimum value

const	SqlUtil::COP_MINUS = "minus"
	the SQL `"minus"` operator

const	SqlUtil::COP_MULTIPLY = "multiply"
	the SQL `"multiply"` operator

const	SqlUtil::COP_NTILE = "ntile"
	Analytic (window) function: NTILE.

const	SqlUtil::COP_OVER = "over"
	the SQL `"over"` clause

const	SqlUtil::COP_PERCENT_RANK = "percent_rank"
	Analytic (window) function: PERCENT_RANK.

const	SqlUtil::COP_PLUS = "plus"
	the SQL `"plus"` operator

const	SqlUtil::COP_PREPEND = "prepend"
	to prepend a string to a column on output

const	SqlUtil::COP_RANK = "rank"
	Analytic (window) function: RANK.

const	SqlUtil::COP_ROW_NUMBER = "row_number"
	Analytic (window) function: ROW_NUMBER.

const	SqlUtil::COP_SEQ = "seq"
	to return the next value of a sequence

const	SqlUtil::COP_SEQ_CURRVAL = "seq_currval"
	to return the last value of a sequence issued in the same session

const	SqlUtil::COP_SUBSTR = "substr"
	to extract a substring from a column

const	SqlUtil::COP_SUM = "sum"
	to return the sum value

const	SqlUtil::COP_TRUNC_DATE = "truncate_date"
	to return the date with truncated value

const	SqlUtil::COP_UPPER = "upper"
	to return column value in upper case

const	SqlUtil::COP_VALUE = "value"
	to append a constant value (SQL Literal) to use as an output column value

const	SqlUtil::COP_YEAR = "year"
	to return a date value with year information only

const	SqlUtil::COP_YEAR_DAY = "year_day"
	to return a date value with year to day information

const	SqlUtil::COP_YEAR_HOUR = "year_hour"
	to return a date value with year to hextern information

const	SqlUtil::COP_YEAR_MONTH = "year_month"
	to return a date value with year to month information

const	SqlUtil::DefaultCopMap = ...
	a hash of default column operator descriptions

Detailed Description

These are the operators that can be used in the "columns" argument for select statements

Variable Documentation

◆ COP_APPEND

const SqlUtil::COP_APPEND = "append"

to append a string to a column on output

See also: cop_append()

◆ COP_AS

const SqlUtil::COP_AS = "as"

to rename a column on output

See also: cop_as()

◆ COP_AVG

const SqlUtil::COP_AVG = "avg"

to return the average value

See also: cop_avg

◆ COP_CAST

const SqlUtil::COP_CAST = "cast"

to convert column value into another datatype

See also: cop_cast()

◆ COP_COALESCE

const SqlUtil::COP_COALESCE = "coalesce"

to return the first non-null argument in the list

See also: cop_coalesce()

◆ COP_COUNT

const SqlUtil::COP_COUNT = "count"

to return the row count

See also: cop_count

◆ COP_CUME_DIST

const SqlUtil::COP_CUME_DIST = "cume_dist"

Analytic (window) function: CUME_DIST.

See also: cop_cume_dist()

Since: SqlUtil 1.4.0

◆ COP_DENSE_RANK

const SqlUtil::COP_DENSE_RANK = "dense_rank"

Analytic (window) function: DENSE_RANK.

See also: cop_dense_rank()

Since: SqlUtil 1.4.0

◆ COP_DISTINCT

const SqlUtil::COP_DISTINCT = "distinct"

to return distinct values

See also: cop_distinct

◆ COP_DIVIDE

const SqlUtil::COP_DIVIDE = "divide"

the SQL "divide" operator

See also: cop_divide()

◆ COP_FIRST_VALUE

const SqlUtil::COP_FIRST_VALUE = "first_value"

Analytic (window) function: FIRST_VALUE.

See also: cop_first_value()

Since: SqlUtil 1.4.0

◆ COP_LAST_VALUE

const SqlUtil::COP_LAST_VALUE = "last_value"

Analytic (window) function: LAST_VALUE.

See also: cop_last_value()

Since: SqlUtil 1.4.0

◆ COP_LENGTH

const SqlUtil::COP_LENGTH = "length"

to get the length of a text field

See also: cop_length()

Since: SqlUtil 1.3.1

◆ COP_LOWER

const SqlUtil::COP_LOWER = "lower"

to return column value in lower case

See also: cop_lower()

◆ COP_MAX

const SqlUtil::COP_MAX = "max"

to return the maximum value

See also: cop_max

◆ COP_MIN

const SqlUtil::COP_MIN = "min"

to return the minimum value

See also: cop_min

◆ COP_MINUS

const SqlUtil::COP_MINUS = "minus"

the SQL "minus" operator

See also: cop_minus()

◆ COP_MULTIPLY

const SqlUtil::COP_MULTIPLY = "multiply"

the SQL "multiply" operator

See also: cop_multiply()

◆ COP_NTILE

const SqlUtil::COP_NTILE = "ntile"

Analytic (window) function: NTILE.

See also: cop_ntile()

Since: SqlUtil 1.4.0

◆ COP_OVER

const SqlUtil::COP_OVER = "over"

the SQL "over" clause

See also: cop_over()

◆ COP_PERCENT_RANK

const SqlUtil::COP_PERCENT_RANK = "percent_rank"

Analytic (window) function: PERCENT_RANK.

See also: cop_percent_rank()

Since: SqlUtil 1.4.0

◆ COP_PLUS

const SqlUtil::COP_PLUS = "plus"

the SQL "plus" operator

See also: cop_plus()

◆ COP_PREPEND

const SqlUtil::COP_PREPEND = "prepend"

to prepend a string to a column on output

See also: cop_prepend()

◆ COP_RANK

const SqlUtil::COP_RANK = "rank"

Analytic (window) function: RANK.

See also: cop_rank()

Since: SqlUtil 1.4.0

◆ COP_ROW_NUMBER

const SqlUtil::COP_ROW_NUMBER = "row_number"

Analytic (window) function: ROW_NUMBER.

See also: cop_row_number()

Since: SqlUtil 1.4.0

◆ COP_SEQ

const SqlUtil::COP_SEQ = "seq"

to return the next value of a sequence

See also: cop_seq()

◆ COP_SEQ_CURRVAL

const SqlUtil::COP_SEQ_CURRVAL = "seq_currval"

to return the last value of a sequence issued in the same session

See also: cop_seq_currval()

◆ COP_SUBSTR

const SqlUtil::COP_SUBSTR = "substr"

to extract a substring from a column

See also: cop_substr()

◆ COP_SUM

const SqlUtil::COP_SUM = "sum"

to return the sum value

See also: cop_sum

◆ COP_TRUNC_DATE

const SqlUtil::COP_TRUNC_DATE = "truncate_date"

to return the date with truncated value

See also: cop_trunc_date()

◆ COP_UPPER

const SqlUtil::COP_UPPER = "upper"

to return column value in upper case

See also: cop_upper()

◆ COP_VALUE

const SqlUtil::COP_VALUE = "value"

to append a constant value (SQL Literal) to use as an output column value

See also: cop_value()

◆ COP_YEAR

const SqlUtil::COP_YEAR = "year"

to return a date value with year information only

See also: cop_year()

◆ COP_YEAR_DAY

const SqlUtil::COP_YEAR_DAY = "year_day"

to return a date value with year to day information

See also: cop_year_day()

◆ COP_YEAR_HOUR

const SqlUtil::COP_YEAR_HOUR = "year_hour"

to return a date value with year to hextern information

See also: cop_year_hour()

◆ COP_YEAR_MONTH

const SqlUtil::COP_YEAR_MONTH = "year_month"

to return a date value with year to month information

See also: cop_year_month()

Classes

Variables