exposed-core/org.jetbrains.exposed.sql.vendors/OracleDialect

OracleDialect

open class OracleDialect : VendorDialect

Oracle dialect implementation.

Constructors

OracleDialect

constructor()

Types

Companion

object Companion : VendorDialect.DialectNameProvider

Properties

allTablesNames

val allTablesNames: List<String>

Returns a list with the names of all the defined tables within default scheme.

dataTypeProvider

open override val dataTypeProvider: DataTypeProvider

Data type provider of this dialect.

defaultReferenceOption

open override val defaultReferenceOption: ReferenceOption

Returns the default reference option for the dialect.

functionProvider

open override val functionProvider: FunctionProvider

Function provider of this dialect.

h2Mode

val DatabaseDialect.h2Mode: H2Dialect.H2CompatibilityMode?

The current H2 database compatibility mode or null if the current database is not H2.

likePatternSpecialChars

open val likePatternSpecialChars: Map<Char, Char?>

Returns a mapping of dialect-specific characters to be escaped when used alongside the LIKE operator.

name

open override val name: String

Name of this dialect.

needsQuotesWhenSymbolsInNames

open override val needsQuotesWhenSymbolsInNames: Boolean = false

Returns true if the dialect requires the use of quotes when using symbols in object names, false otherwise.

needsSequenceToAutoInc

open override val needsSequenceToAutoInc: Boolean = true

Returns true if the dialect requires the use of a sequence to create an auto-increment column, false otherwise.

requiresAutoCommitOnCreateDrop

open val requiresAutoCommitOnCreateDrop: Boolean

Returns true if autoCommit should be enabled to create/drop a database.

supportsCreateSchema

open val supportsCreateSchema: Boolean

Returnstrue if the dialect supports schema creation.

supportsCreateSequence

open val supportsCreateSequence: Boolean

Returns true if the dialect supports the creation of sequences, false otherwise.

supportsDualTableConcept

open override val supportsDualTableConcept: Boolean = true

Returns true if the dialect provides a special dummy DUAL table, accessible by all users.

supportsIfNotExists

open override val supportsIfNotExists: Boolean = false

Returns true if the dialect supports the IF EXISTS/IF NOT EXISTS option when creating, altering or dropping objects, false otherwise.

supportsMultipleGeneratedKeys

open override val supportsMultipleGeneratedKeys: Boolean = false

Returns true if the dialect supports returning multiple generated keys as a result of an insert operation, false otherwise.

supportsOnlyIdentifiersInGeneratedKeys

open override val supportsOnlyIdentifiersInGeneratedKeys: Boolean = true

Returns true if the dialect supports only returning generated keys that are identity columns.

supportsOnUpdate

open override val supportsOnUpdate: Boolean = false

Returns true if the dialect supports using the ON UPDATE clause with a foreign key constraint.

supportsOrderByNullsFirstLast

open override val supportsOrderByNullsFirstLast: Boolean = true

Returns true if the dialect provides options to configure how nulls are sorted compared to non-null values.

supportsRestrictReferenceOption

open override val supportsRestrictReferenceOption: Boolean = false

Returns true if the dialect supports the RESTRICT action as part of a foreign key constraint clause.

supportsSequenceAsGeneratedKeys

open val supportsSequenceAsGeneratedKeys: Boolean

Returns true if the dialect supports returning generated keys obtained from a sequence.

supportsSetDefaultReferenceOption

open override val supportsSetDefaultReferenceOption: Boolean = false

Returns true if the dialect supports the SET DEFAULT action as part of a foreign key constraint clause.

supportsSubqueryUnions

open val supportsSubqueryUnions: Boolean

Returns true if the dialect supports subqueries within a UNION/EXCEPT/INTERSECT statement.

supportsTernaryAffectedRowValues

open val supportsTernaryAffectedRowValues: Boolean

Returns true if the dialect supports an upsert operation returning an affected-row value of 0, 1, or 2.

supportsWindowFrameGroupsMode

open val supportsWindowFrameGroupsMode: Boolean

Returns true if the dialect supports window function definitions with GROUPS mode in frame clause

Functions

addPrimaryKey

open override fun addPrimaryKey(table: Table, pkName: String?, vararg pkColumns: Column<*>): String

Returns the SQL statement that adds a primary key specified pkName to an existing table.

allTablesNames

open override fun allTablesNames(): List<String>

Returns a list with the names of all the defined tables with schema prefixes if database supports it. This method always re-read data from DB. Using allTablesNames field is the preferred way.

catalog

open fun catalog(transaction: Transaction): String

Returns the catalog name of the connection of the specified transaction.

checkTableMapping

open fun checkTableMapping(table: Table): Boolean

columnConstraints

open override fun columnConstraints(vararg tables: Table): Map<Pair<Table, LinkedHashSet<Column<*>>>, List<ForeignKeyConstraint>>

Returns a map with the foreign key constraints of all the defined columns sets in each of the specified tables.

createDatabase

open override fun createDatabase(name: String): String

Returns the SQL statement that creates a database with the specified name.

createIndex

open override fun createIndex(index: Index): String

Uniqueness might be required for foreign key constraints.

createSchema

open override fun createSchema(schema: Schema): String

Returns the SQL statement that creates the specified schema.

dropDatabase

open override fun dropDatabase(name: String): String

Returns the SQL statement that drops the database with the specified name.

dropIndex

open override fun dropIndex(tableName: String, indexName: String, isUnique: Boolean, isPartialOrFunctional: Boolean): String

Returns the SQL statement that drops the specified indexName from the specified tableName.

dropSchema

open override fun dropSchema(schema: Schema, cascade: Boolean): String

Returns the SQL statement that drops the specified schema, as well as all its objects if cascade is true.

existingIndices

open override fun existingIndices(vararg tables: Table): Map<Table, List<Index>>

Returns a map with all the defined indices in each of the specified tables.

existingPrimaryKeys

open override fun existingPrimaryKeys(vararg tables: Table): Map<Table, PrimaryKeyMetadata?>

Returns a map with the primary key metadata in each of the specified tables.

filterCondition

fun filterCondition(index: Index): String?

getDatabase

open override fun getDatabase(): String

Returns the name of the current database.

isAllowedAsColumnDefault

open override fun isAllowedAsColumnDefault(e: Expression<*>): Boolean

Returns true if the specified e is allowed as a default column value in the dialect, false otherwise.

listDatabases

open override fun listDatabases(): String

Returns the SQL query that retrieves a set of existing databases.

modifyColumn

open override fun modifyColumn(column: Column<*>, columnDiff: ColumnDiff): List<String>

Returns the SQL statement that modifies the specified column.

resetCaches

open override fun resetCaches()

Clears any cached values.

resetSchemaCaches

open override fun resetSchemaCaches()

Clears any cached values including schema names.

resolveRefOptionFromJdbc

open override fun resolveRefOptionFromJdbc(refOption: Int): ReferenceOption

The SQL that gets the constraint information for Oracle returns a 1 for NO ACTION and does not support RESTRICT. decode (f.delete_rule, 'CASCADE', 0, 'SET NULL', 2, 1) as delete_rule

schemaExists