Liquibase 4.26.0 · liquibase.database.core.OracleDatabase

Modifier and Type	Field and Description
private Boolean	canAccessDbaRecycleBin
private static final ResourceBundle	coreBundle
private Integer	databaseMajorVersion
private Integer	databaseMinorVersion
protected final int	LONG_IDENTIFIERS_LEGNTH
public static final int	ORACLE_12C_MAJOR_VERSION
public static final int	ORACLE_23C_MAJOR_VERSION
public static final String	PRODUCT_NAME
public static final Pattern	PROXY_USER_PATTERN
private static final String	PROXY_USER_REGEX
private final Set<String>	reservedWords Hides liquibase.database.AbstractJdbcDatabase.reservedWords.
private Map<String, String>	savedSessionNlsSettings
protected final int	SHORT_IDENTIFIERS_LENGTH
private Set<String>	userDefinedTypes
private static final Pattern	VERSION_PATTERN
private static final String	VERSION_REGEX

Access	Constructor and Description
public	OracleDatabase() Default constructor for an object that represents the Oracle Database DBMS.

Modifier and Type	Method and Description
public boolean	canAccessDbaRecycleBin()
public String	generateDatabaseFunctionValue(DatabaseFunction database function to check. databaseFunction) Overrides liquibase.database.AbstractJdbcDatabase.generateDatabaseFunctionValue. Implements liquibase.database.Database.generateDatabaseFunctionValue. Some function names are placeholders that need to be replaced with the specific database value.
public String	generatePrimaryKeyName(String tableName) Overrides liquibase.database.AbstractJdbcDatabase.generatePrimaryKeyName. Implements liquibase.database.Database.generatePrimaryKeyName.
protected String	getAutoIncrementClause(final String generationType, final Boolean defaultOnNull) Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause. Default implementation.
protected String	getConnectionCatalogName() Overrides liquibase.database.AbstractJdbcDatabase.getConnectionCatalogName.
public int	getDatabaseMajorVersion() Overrides liquibase.database.AbstractJdbcDatabase.getDatabaseMajorVersion. Implements liquibase.database.Database.getDatabaseMajorVersion.
public int	getDatabaseMinorVersion() Overrides liquibase.database.AbstractJdbcDatabase.getDatabaseMinorVersion. Implements liquibase.database.Database.getDatabaseMinorVersion.
public int	getDataTypeMaxParameters(String dataTypeName) Overrides liquibase.database.AbstractJdbcDatabase.getDataTypeMaxParameters. Implements liquibase.database.Database.getDataTypeMaxParameters.
public String	getDateLiteral(String isoDate) Overrides liquibase.database.AbstractJdbcDatabase.getDateLiteral. Implements liquibase.database.Database.getDateLiteral. Returns an Oracle date literal with the same value as a string formatted using ISO 8601.
public String	getDbaRecycleBinWarning()
public String	getDefaultCatalogName() Overrides liquibase.database.AbstractJdbcDatabase.getDefaultCatalogName. Implements liquibase.database.Database.getDefaultCatalogName.
protected String	getDefaultDatabaseProductName() Implements abstract liquibase.database.AbstractJdbcDatabase.getDefaultDatabaseProductName.
public String	getDefaultDriver(String url) Implements liquibase.database.Database.getDefaultDriver. If this database understands the given url, return the default driver class name.
public Integer	getDefaultPort() Implements liquibase.database.Database.getDefaultPort.
public int	Returns: the maximum length of an object identifier, in bytes getIdentifierMaximumLength() Returns the maximum number of bytes (NOT: characters) for an identifier.
public String	getJdbcCatalogName(CatalogAndSchema schema) Overrides liquibase.database.AbstractJdbcDatabase.getJdbcCatalogName.
public String	getJdbcSchemaName(CatalogAndSchema schema) Overrides liquibase.database.AbstractJdbcDatabase.getJdbcSchemaName.
public int	getPriority() Implements liquibase.servicelocator.PrioritizedService.getPriority.
public String	getShortName() Implements liquibase.database.Database.getShortName. Returns an all-lower-case short name of the product.
public String	getSystemTableWhereClause(String tableNameColumn)
public Set<String>	getUserDefinedTypes()
public boolean	isCorrectDatabaseImplementation(DatabaseConnection conn) Implements liquibase.database.Database.isCorrectDatabaseImplementation. Is this AbstractDatabase subclass the correct one to use for the given connection.
public boolean	isReservedWord(String objectName) Overrides liquibase.database.AbstractJdbcDatabase.isReservedWord. Implements liquibase.database.Database.isReservedWord.
public boolean	isSystemObject(DatabaseObject example) Overrides liquibase.database.AbstractJdbcDatabase.isSystemObject. Implements liquibase.database.Database.isSystemObject.
public boolean	isValidOracleIdentifier(String identifier, Class<? extends DatabaseObject> type) Tests if the given String would be a valid identifier in Oracle DBMS.
public boolean	jdbcCallsCatalogsSchemas() Overrides liquibase.database.AbstractJdbcDatabase.jdbcCallsCatalogsSchemas.
public void	setConnection(DatabaseConnection conn) Overrides liquibase.database.AbstractJdbcDatabase.setConnection. Implements liquibase.database.Database.setConnection.
public boolean	supportsAutoIncrement() Overrides liquibase.database.AbstractJdbcDatabase.supportsAutoIncrement. Implements liquibase.database.Database.supportsAutoIncrement.
public boolean	supportsInitiallyDeferrableColumns() Implements liquibase.database.Database.supportsInitiallyDeferrableColumns. Returns whether this database support initially deferrable columns.
public boolean	supportsNotNullConstraintNames() Overrides liquibase.database.AbstractJdbcDatabase.supportsNotNullConstraintNames. Implements liquibase.database.Database.supportsNotNullConstraintNames. Does this database treat NOT NULL as an own kind of CONSTRAINT (in addition of simply being a column property)?
public boolean	supportsRestrictForeignKeys() Overrides liquibase.database.AbstractJdbcDatabase.supportsRestrictForeignKeys. Implements liquibase.database.Database.supportsRestrictForeignKeys.
public boolean	Returns: false supportsSchemas() Overrides liquibase.database.AbstractJdbcDatabase.supportsSchemas. Implements liquibase.database.Database.supportsSchemas. Oracle supports catalogs in liquibase terms
public boolean	supportsSequences() Overrides liquibase.database.AbstractJdbcDatabase.supportsSequences. Implements liquibase.database.Database.supportsSequences. Does the database type support sequence.
public boolean	supportsTablespaces() Implements liquibase.database.Database.supportsTablespaces.
private void	tryProxySession(final String url, final Connection con)
public ValidationErrors	validate() Overrides liquibase.database.AbstractJdbcDatabase.validate. Implements liquibase.database.Database.validate.

canAccessDbaRecycleBin	back to summary
private Boolean canAccessDbaRecycleBin

coreBundle	back to summary
private static final ResourceBundle coreBundle

databaseMajorVersion	back to summary
private Integer databaseMajorVersion

databaseMinorVersion	back to summary
private Integer databaseMinorVersion

LONG_IDENTIFIERS_LEGNTH	back to summary
protected final int LONG_IDENTIFIERS_LEGNTH

ORACLE_12C_MAJOR_VERSION	back to summary
public static final int ORACLE_12C_MAJOR_VERSION

ORACLE_23C_MAJOR_VERSION	back to summary
public static final int ORACLE_23C_MAJOR_VERSION

PRODUCT_NAME	back to summary
public static final String PRODUCT_NAME

PROXY_USER_PATTERN	back to summary
public static final Pattern PROXY_USER_PATTERN

PROXY_USER_REGEX	back to summary
private static final String PROXY_USER_REGEX

reservedWords	back to summary
private final Set<String> reservedWords Hides liquibase.database.AbstractJdbcDatabase.reservedWords.

savedSessionNlsSettings	back to summary
private Map<String, String> savedSessionNlsSettings

SHORT_IDENTIFIERS_LENGTH	back to summary
protected final int SHORT_IDENTIFIERS_LENGTH

userDefinedTypes	back to summary
private Set<String> userDefinedTypes

VERSION_PATTERN	back to summary
private static final Pattern VERSION_PATTERN

VERSION_REGEX	back to summary
private static final String VERSION_REGEX

OracleDatabase	back to summary
public OracleDatabase() Default constructor for an object that represents the Oracle Database DBMS.

Method Detail

canAccessDbaRecycleBin	back to summary
public boolean canAccessDbaRecycleBin()

generateDatabaseFunctionValue	back to summary
public String generateDatabaseFunctionValue(DatabaseFunction databaseFunction) Overrides liquibase.database.AbstractJdbcDatabase.generateDatabaseFunctionValue. Implements liquibase.database.Database.generateDatabaseFunctionValue. Doc from liquibase.database.Database.generateDatabaseFunctionValue. Some function names are placeholders that need to be replaced with the specific database value. e.g. nextSequenceValue(sequenceName) should be replaced with NEXT_VAL('sequenceName') for Postgresql Parameters databaseFunction:DatabaseFunction database function to check. Returns:String the string value to use for an update or generate Annotations @Override

generateDatabaseFunctionValue

back to summary

public String generateDatabaseFunctionValue(DatabaseFunction databaseFunction)

Overrides liquibase.database.AbstractJdbcDatabase.generateDatabaseFunctionValue.

Implements liquibase.database.Database.generateDatabaseFunctionValue.

Doc from liquibase.database.Database.generateDatabaseFunctionValue.

Some function names are placeholders that need to be replaced with the specific database value. e.g. nextSequenceValue(sequenceName) should be replaced with NEXT_VAL('sequenceName') for Postgresql

Parameters

databaseFunction:DatabaseFunction: database function to check.

Returns:String

the string value to use for an update or generate

Annotations

@Override

generatePrimaryKeyName	back to summary
public String generatePrimaryKeyName(String tableName) Overrides liquibase.database.AbstractJdbcDatabase.generatePrimaryKeyName. Implements liquibase.database.Database.generatePrimaryKeyName. Annotations @Override

generatePrimaryKeyName

back to summary

public String generatePrimaryKeyName(String tableName)

Overrides liquibase.database.AbstractJdbcDatabase.generatePrimaryKeyName.

Implements liquibase.database.Database.generatePrimaryKeyName.

Annotations

@Override

getAutoIncrementClause	back to summary
protected String getAutoIncrementClause(final String generationType, final Boolean defaultOnNull) Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause. Doc from liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause. Default implementation. Intended for override in database specific cases Annotations @Override

getAutoIncrementClause

back to summary

protected String getAutoIncrementClause(final String generationType, final Boolean defaultOnNull)

Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause.

Doc from liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause.

Default implementation. Intended for override in database specific cases

Annotations

@Override

getConnectionCatalogName	back to summary
protected String getConnectionCatalogName() throws DatabaseException Overrides liquibase.database.AbstractJdbcDatabase.getConnectionCatalogName. Annotations @Override

getConnectionCatalogName

back to summary

protected String getConnectionCatalogName() throws DatabaseException

Overrides liquibase.database.AbstractJdbcDatabase.getConnectionCatalogName.

Annotations

@Override

getDatabaseMajorVersion	back to summary
public int getDatabaseMajorVersion() throws DatabaseException Overrides liquibase.database.AbstractJdbcDatabase.getDatabaseMajorVersion. Implements liquibase.database.Database.getDatabaseMajorVersion. Annotations @Override

getDatabaseMajorVersion

back to summary

public int getDatabaseMajorVersion() throws DatabaseException

Overrides liquibase.database.AbstractJdbcDatabase.getDatabaseMajorVersion.

Implements liquibase.database.Database.getDatabaseMajorVersion.

Annotations

@Override

getDatabaseMinorVersion	back to summary
public int getDatabaseMinorVersion() throws DatabaseException Overrides liquibase.database.AbstractJdbcDatabase.getDatabaseMinorVersion. Implements liquibase.database.Database.getDatabaseMinorVersion. Annotations @Override

getDatabaseMinorVersion

back to summary

public int getDatabaseMinorVersion() throws DatabaseException

Overrides liquibase.database.AbstractJdbcDatabase.getDatabaseMinorVersion.

Implements liquibase.database.Database.getDatabaseMinorVersion.

Annotations

@Override

getDataTypeMaxParameters	back to summary
public int getDataTypeMaxParameters(String dataTypeName) Overrides liquibase.database.AbstractJdbcDatabase.getDataTypeMaxParameters. Implements liquibase.database.Database.getDataTypeMaxParameters. Annotations @Override

getDataTypeMaxParameters

back to summary

public int getDataTypeMaxParameters(String dataTypeName)

Overrides liquibase.database.AbstractJdbcDatabase.getDataTypeMaxParameters.

Implements liquibase.database.Database.getDataTypeMaxParameters.

Annotations

@Override

getDateLiteral	back to summary
public String getDateLiteral(String isoDate) Overrides liquibase.database.AbstractJdbcDatabase.getDateLiteral. Implements liquibase.database.Database.getDateLiteral. Returns an Oracle date literal with the same value as a string formatted using ISO 8601. Convert an ISO8601 date string to one of the following results: to_date('1995-05-23', 'YYYY-MM-DD') to_date('1995-05-23 09:23:59', 'YYYY-MM-DD HH24:MI:SS') Implementation restriction: Currently, only the following subsets of ISO8601 are supported: YYYY-MM-DD YYYY-MM-DDThh:mm:ss Annotations @Override

getDateLiteral

back to summary

public String getDateLiteral(String isoDate)

Overrides liquibase.database.AbstractJdbcDatabase.getDateLiteral.

Implements liquibase.database.Database.getDateLiteral.

Returns an Oracle date literal with the same value as a string formatted using ISO 8601.

Convert an ISO8601 date string to one of the following results: to_date('1995-05-23', 'YYYY-MM-DD') to_date('1995-05-23 09:23:59', 'YYYY-MM-DD HH24:MI:SS')

Implementation restriction:
Currently, only the following subsets of ISO8601 are supported:

YYYY-MM-DD
YYYY-MM-DDThh:mm:ss

Annotations

@Override

getDbaRecycleBinWarning	back to summary
public String getDbaRecycleBinWarning()

getDefaultCatalogName	back to summary
public String getDefaultCatalogName() Overrides liquibase.database.AbstractJdbcDatabase.getDefaultCatalogName. Implements liquibase.database.Database.getDefaultCatalogName. Annotations @Override

getDefaultCatalogName

back to summary

public String getDefaultCatalogName()

Overrides liquibase.database.AbstractJdbcDatabase.getDefaultCatalogName.

Implements liquibase.database.Database.getDefaultCatalogName.

Annotations

@Override

getDefaultDatabaseProductName	back to summary
protected String getDefaultDatabaseProductName() Implements abstract liquibase.database.AbstractJdbcDatabase.getDefaultDatabaseProductName. Annotations @Override

getDefaultDatabaseProductName

back to summary

protected String getDefaultDatabaseProductName()

Implements abstract liquibase.database.AbstractJdbcDatabase.getDefaultDatabaseProductName.

Annotations

@Override

getDefaultDriver	back to summary
public String getDefaultDriver(String url) Implements liquibase.database.Database.getDefaultDriver. Doc from liquibase.database.Database.getDefaultDriver. If this database understands the given url, return the default driver class name. Otherwise return null. Annotations @Override

getDefaultDriver

back to summary

public String getDefaultDriver(String url)

Implements liquibase.database.Database.getDefaultDriver.

Doc from liquibase.database.Database.getDefaultDriver.

If this database understands the given url, return the default driver class name. Otherwise return null.

Annotations

@Override

getDefaultPort	back to summary
public Integer getDefaultPort() Implements liquibase.database.Database.getDefaultPort. Annotations @Override

getDefaultPort

back to summary

public Integer getDefaultPort()

Implements liquibase.database.Database.getDefaultPort.

Annotations

@Override

getIdentifierMaximumLength	back to summary
public int getIdentifierMaximumLength() Returns the maximum number of bytes (NOT: characters) for an identifier. For Oracle <=12c Release 20, this is 30 bytes, and starting from 12cR2, up to 128 (except for tablespaces, PDB names and some other rather rare object types). Returns:int the maximum length of an object identifier, in bytes

getIdentifierMaximumLength

back to summary

public int getIdentifierMaximumLength()

Returns the maximum number of bytes (NOT: characters) for an identifier. For Oracle <=12c Release 20, this is 30 bytes, and starting from 12cR2, up to 128 (except for tablespaces, PDB names and some other rather rare object types).

Returns:int: the maximum length of an object identifier, in bytes

getJdbcCatalogName	back to summary
public String getJdbcCatalogName(CatalogAndSchema schema) Overrides liquibase.database.AbstractJdbcDatabase.getJdbcCatalogName. Annotations @Override

getJdbcCatalogName

back to summary

public String getJdbcCatalogName(CatalogAndSchema schema)

Overrides liquibase.database.AbstractJdbcDatabase.getJdbcCatalogName.

Annotations

@Override

getJdbcSchemaName	back to summary
public String getJdbcSchemaName(CatalogAndSchema schema) Overrides liquibase.database.AbstractJdbcDatabase.getJdbcSchemaName. Annotations @Override

getJdbcSchemaName

back to summary

public String getJdbcSchemaName(CatalogAndSchema schema)

Overrides liquibase.database.AbstractJdbcDatabase.getJdbcSchemaName.

Annotations

@Override

getPriority	back to summary
public int getPriority() Implements liquibase.servicelocator.PrioritizedService.getPriority. Annotations @Override

getPriority

back to summary

public int getPriority()

Implements liquibase.servicelocator.PrioritizedService.getPriority.

Annotations

@Override

getShortName	back to summary
public String getShortName() Implements liquibase.database.Database.getShortName. Doc from liquibase.database.Database.getShortName. Returns an all-lower-case short name of the product. Used for end-user selecting of database type such as the DBMS precondition. Annotations @Override

getShortName

back to summary

public String getShortName()

Implements liquibase.database.Database.getShortName.

Doc from liquibase.database.Database.getShortName.

Returns an all-lower-case short name of the product. Used for end-user selecting of database type such as the DBMS precondition.

Annotations

@Override

getSystemTableWhereClause	back to summary
public String getSystemTableWhereClause(String tableNameColumn)

getUserDefinedTypes	back to summary
public Set<String> getUserDefinedTypes()

isCorrectDatabaseImplementation	back to summary
public boolean isCorrectDatabaseImplementation(DatabaseConnection conn) throws DatabaseException Implements liquibase.database.Database.isCorrectDatabaseImplementation. Doc from liquibase.database.Database.isCorrectDatabaseImplementation. Is this AbstractDatabase subclass the correct one to use for the given connection. Annotations @Override

isCorrectDatabaseImplementation

back to summary

public boolean isCorrectDatabaseImplementation(DatabaseConnection conn) throws DatabaseException

Implements liquibase.database.Database.isCorrectDatabaseImplementation.

Doc from liquibase.database.Database.isCorrectDatabaseImplementation.

Is this AbstractDatabase subclass the correct one to use for the given connection.

Annotations

@Override

isReservedWord	back to summary
public boolean isReservedWord(String objectName) Overrides liquibase.database.AbstractJdbcDatabase.isReservedWord. Implements liquibase.database.Database.isReservedWord. Annotations @Override

isReservedWord

back to summary

public boolean isReservedWord(String objectName)

Overrides liquibase.database.AbstractJdbcDatabase.isReservedWord.

Implements liquibase.database.Database.isReservedWord.

Annotations

@Override

isSystemObject	back to summary
public boolean isSystemObject(DatabaseObject example) Overrides liquibase.database.AbstractJdbcDatabase.isSystemObject. Implements liquibase.database.Database.isSystemObject. Annotations @Override

isSystemObject

back to summary

public boolean isSystemObject(DatabaseObject example)

Overrides liquibase.database.AbstractJdbcDatabase.isSystemObject.

Implements liquibase.database.Database.isSystemObject.

Annotations

@Override

isValidOracleIdentifier	back to summary
public boolean isValidOracleIdentifier(String identifier, Class<? extends DatabaseObject> type) Tests if the given String would be a valid identifier in Oracle DBMS. In Oracle, a valid identifier has the following form (case-insensitive comparison): 1st character: A-Z 2..n characters: A-Z0-9$_# The maximum length of an identifier differs by Oracle version and object type.

jdbcCallsCatalogsSchemas	back to summary
public boolean jdbcCallsCatalogsSchemas() Overrides liquibase.database.AbstractJdbcDatabase.jdbcCallsCatalogsSchemas. Annotations @Override

jdbcCallsCatalogsSchemas

back to summary

public boolean jdbcCallsCatalogsSchemas()

Overrides liquibase.database.AbstractJdbcDatabase.jdbcCallsCatalogsSchemas.

Annotations

@Override

setConnection	back to summary
public void setConnection(DatabaseConnection conn) Overrides liquibase.database.AbstractJdbcDatabase.setConnection. Implements liquibase.database.Database.setConnection. Annotations @Override

setConnection

back to summary

public void setConnection(DatabaseConnection conn)

Overrides liquibase.database.AbstractJdbcDatabase.setConnection.

Implements liquibase.database.Database.setConnection.

Annotations

@Override

supportsAutoIncrement	back to summary
public boolean supportsAutoIncrement() Overrides liquibase.database.AbstractJdbcDatabase.supportsAutoIncrement. Implements liquibase.database.Database.supportsAutoIncrement. Annotations @Override

supportsAutoIncrement

back to summary

public boolean supportsAutoIncrement()

Overrides liquibase.database.AbstractJdbcDatabase.supportsAutoIncrement.

Implements liquibase.database.Database.supportsAutoIncrement.

Annotations

@Override

supportsInitiallyDeferrableColumns	back to summary
public boolean supportsInitiallyDeferrableColumns() Implements liquibase.database.Database.supportsInitiallyDeferrableColumns. Doc from liquibase.database.Database.supportsInitiallyDeferrableColumns. Returns whether this database support initially deferrable columns. Annotations @Override

supportsInitiallyDeferrableColumns

back to summary

public boolean supportsInitiallyDeferrableColumns()

Implements liquibase.database.Database.supportsInitiallyDeferrableColumns.

Doc from liquibase.database.Database.supportsInitiallyDeferrableColumns.

Returns whether this database support initially deferrable columns.

Annotations

@Override

supportsNotNullConstraintNames	back to summary
public boolean supportsNotNullConstraintNames() Overrides liquibase.database.AbstractJdbcDatabase.supportsNotNullConstraintNames. Implements liquibase.database.Database.supportsNotNullConstraintNames. Doc from liquibase.database.Database.supportsNotNullConstraintNames. Does this database treat NOT NULL as an own kind of CONSTRAINT (in addition of simply being a column property)? This will affect the CONSTRAINT clause SQL generators. Returns:boolean true if the database supports naming NOT NULL constraints, false if not. Annotations @Override

supportsNotNullConstraintNames

back to summary

public boolean supportsNotNullConstraintNames()

Overrides liquibase.database.AbstractJdbcDatabase.supportsNotNullConstraintNames.

Implements liquibase.database.Database.supportsNotNullConstraintNames.

Doc from liquibase.database.Database.supportsNotNullConstraintNames.

Does this database treat NOT NULL as an own kind of CONSTRAINT (in addition of simply being a column property)? This will affect the CONSTRAINT clause SQL generators.

Returns:boolean

true if the database supports naming NOT NULL constraints, false if not.

Annotations