Package org.apache.calcite.sql.fun

Class OracleSqlOperatorTable

java.lang.Object

org.apache.calcite.sql.util.ReflectiveSqlOperatorTable

org.apache.calcite.sql.fun.OracleSqlOperatorTable

All Implemented Interfaces:

SqlOperatorTable

public class OracleSqlOperatorTable
extends ReflectiveSqlOperatorTable

Operator table that contains only Oracle-specific functions and operators.

Field Summary

Fields

Modifier and Type	Field	Description
static SqlFunction	DECODE	The "DECODE(v, v1, result1, [v2, result2, ...], resultN)" function.
protected static SqlReturnTypeInference	DECODE_RETURN_TYPE	Return type inference for DECODE.
static SqlFunction	GREATEST	The "GREATEST(value, value)" function.
private static OracleSqlOperatorTable	instance	The table of contains Oracle-specific operators.
static SqlFunction	LEAST	The "LEAST(value, value)" function.
static SqlFunction	LTRIM	The "LTRIM(string)" function.
static SqlFunction	NVL	The "NVL(value, value)" function.
static SqlFunction	RTRIM	The "RTRIM(string)" function.
static SqlFunction	SUBSTR	Oracle's "SUBSTR(string, position [, substringLength ])" function.
static SqlFunction	TRANSLATE3	The TRANSLATE(string_expr, search_chars, replacement_chars) function returns string_expr with all occurrences of each character in search_chars replaced by its corresponding character in replacement_chars.

Fields inherited from class org.apache.calcite.sql.util.ReflectiveSqlOperatorTable

IS_NAME

Constructor Summary

Constructors

Constructor	Description
OracleSqlOperatorTable()

Method Summary

Modifier and Type	Method	Description
static OracleSqlOperatorTable	instance()	Returns the Oracle operator table, creating it if necessary.

Methods inherited from class org.apache.calcite.sql.util.ReflectiveSqlOperatorTable

getOperatorList, init, lookupOperatorOverloads, register

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

instance

private static OracleSqlOperatorTable instance

The table of contains Oracle-specific operators.

DECODE_RETURN_TYPE

protected static final SqlReturnTypeInference DECODE_RETURN_TYPE

Return type inference for DECODE.

DECODE

public static final SqlFunction DECODE

The "DECODE(v, v1, result1, [v2, result2, ...], resultN)" function.

NVL

public static final SqlFunction NVL

The "NVL(value, value)" function.

LTRIM

public static final SqlFunction LTRIM

The "LTRIM(string)" function.

RTRIM

public static final SqlFunction RTRIM

The "RTRIM(string)" function.

SUBSTR

public static final SqlFunction SUBSTR

Oracle's "SUBSTR(string, position [, substringLength ])" function.

It has similar semantics to standard SQL's SqlStdOperatorTable.SUBSTRING function but different syntax.

GREATEST

public static final SqlFunction GREATEST

The "GREATEST(value, value)" function.

LEAST

public static final SqlFunction LEAST

The "LEAST(value, value)" function.

TRANSLATE3

public static final SqlFunction TRANSLATE3

The TRANSLATE(string_expr, search_chars, replacement_chars) function returns string_expr with all occurrences of each character in search_chars replaced by its corresponding character in replacement_chars.

It is not defined in the SQL standard, but occurs in Oracle and PostgreSQL.

Constructor Detail

OracleSqlOperatorTable

public OracleSqlOperatorTable()

Method Detail

instance

public static OracleSqlOperatorTable instance()

Returns the Oracle operator table, creating it if necessary.