Package org.apache.calcite.sql.dialect

Class OracleSqlDialect

java.lang.Object

org.apache.calcite.sql.SqlDialect

org.apache.calcite.sql.dialect.OracleSqlDialect

public class OracleSqlDialect
extends SqlDialect

A SqlDialect implementation for the Oracle database.

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.calcite.sql.SqlDialect

SqlDialect.CalendarPolicy, SqlDialect.Context, SqlDialect.DatabaseProduct, SqlDialect.FakeUtil

Field Summary

Fields

Modifier and Type	Field	Description
static SqlDialect	DEFAULT

Fields inherited from class org.apache.calcite.sql.SqlDialect

BUILT_IN_OPERATORS_LIST, CALCITE, DUMMY, EMPTY_CONTEXT, LOGGER, nullCollation

Constructor Summary

Constructors

Constructor	Description
OracleSqlDialect(SqlDialect.Context context)	Creates an OracleSqlDialect.

Method Summary

Modifier and Type	Method	Description
protected boolean	allowsAs()
boolean	supportsAliasedValues()	Returns whether the dialect supports VALUES in a sub-query with and an "AS t(column, ...)" values to define column names.
boolean	supportsCharSet()	Returns whether the dialect supports character set names as part of a data type, for instance VARCHAR(30) CHARACTER SET `ISO-8859-1`.
void	unparseCall(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec)

Methods inherited from class org.apache.calcite.sql.SqlDialect

create, defaultNullDirection, emptyContext, emulateNullDirection, emulateNullDirectionWithIsNull, getCalendarPolicy, getCastSpec, getDatabaseProduct, getNullCollation, getProduct, getTypeSystem, hasImplicitTableAlias, identifierNeedsToBeQuoted, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteStringLiteral, quoteStringLiteralUnicode, quoteTimestampLiteral, requiresAliasForFromItems, rewriteSingleValueExpr, supportsAggregateFunction, supportsFunction, supportsNestedAggregations, supportsOffsetFetch, supportsWindowFunctions, unparseDateTimeLiteral, unparseFetchUsingAnsi, unparseFetchUsingLimit, unparseOffsetFetch, unparseSqlDatetimeArithmetic, unparseSqlIntervalLiteral, unparseSqlIntervalQualifier, unquoteStringLiteral

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT

public static final SqlDialect DEFAULT

Constructor Detail

OracleSqlDialect

public OracleSqlDialect(SqlDialect.Context context)

Creates an OracleSqlDialect.

Method Detail

supportsCharSet

public boolean supportsCharSet()

Description copied from class: SqlDialect

Returns whether the dialect supports character set names as part of a data type, for instance VARCHAR(30) CHARACTER SET `ISO-8859-1`.

Overrides:

supportsCharSet in class SqlDialect

allowsAs

protected boolean allowsAs()

Overrides:

allowsAs in class SqlDialect

supportsAliasedValues

public boolean supportsAliasedValues()

Description copied from class: SqlDialect

Returns whether the dialect supports VALUES in a sub-query with and an "AS t(column, ...)" values to define column names.

Currently, only Oracle does not. For this, we generate "SELECT v0 AS c0, v1 AS c1 ... UNION ALL ...". We may need to refactor this method when we support VALUES for other dialects.

Overrides:

supportsAliasedValues in class SqlDialect

unparseCall

public void unparseCall(SqlWriter writer,
                        SqlCall call,
                        int leftPrec,
                        int rightPrec)

Overrides:

unparseCall in class SqlDialect