Property Name | Value
--- | ---
allProceduresAreCallable | false
allTablesAreSelectable | false
dataDefinitionCausesTransactionCommit | true
dataDefinitionIgnoredInTransactions | false
doesMaxRowSizeIncludeBlobs | true
getCatalogSeparator |
getCatalogTerm |
getDatabaseMajorVersion | 9
getDatabaseMinorVersion | 2
getDatabaseProductName | Oracle
getDatabaseProductVersion | Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production
getDefaultTransactionIsolation | TRANSACTION_READ_COMMITTED
getDriverMajorVersion | 10
getDriverMinorVersion | 2
getDriverName | Oracle JDBC driver
getDriverVersion | 10.2.0.1.0
getExtraNameCharacters | $#
getIdentifierQuoteString | "
getJDBCMajorVersion | 10
getJDBCMinorVersion | 2
getMaxBinaryLiteralLength | 1000
getMaxCatalogNameLength | 0
getMaxCharLiteralLength | 2000
getMaxColumnNameLength | 30
getMaxColumnsInGroupBy | 0
getMaxColumnsInIndex | 32
getMaxColumnsInOrderBy | 0
getMaxColumnsInSelect | 0
getMaxColumnsInTable | 1000
getMaxConnections | 0
getMaxCursorNameLength | 0
getMaxIndexLength | 0
getMaxProcedureNameLength | 30
getMaxRowSize | 2000
getMaxSchemaNameLength | 30
getMaxStatementLength | 65535
getMaxStatements | 0
getMaxTableNameLength | 30
getMaxTablesInSelect | 0
getMaxUserNameLength | 30
getProcedureTerm | procedure
getResultSetHoldability | 1
getSchemaTerm | schema
getSearchStringEscape | //
getSQLStateType | 0
getURL | jdbc:oracle:thin:@localhost:1521:csuite
getUserName | CSUITE
isCatalogAtStart | false
isReadOnly | false
locatorsUpdateCopy | true
nullPlusNonNullIsNull | true
nullsAreSortedAtEnd | false
nullsAreSortedAtStart | false
nullsAreSortedHigh | false
nullsAreSortedLow | true
storesLowerCaseIdentifiers | false
storesLowerCaseQuotedIdentifiers | false
storesMixedCaseIdentifiers | false
storesMixedCaseQuotedIdentifiers | true
storesUpperCaseIdentifiers | true
storesUpperCaseQuotedIdentifiers | false
supportsAlterTableWithAddColumn | true
supportsAlterTableWithDropColumn | false
supportsANSI92EntryLevelSQL | true
supportsANSI92FullSQL | false
supportsANSI92IntermediateSQL | false
supportsBatchUpdates | true
supportsCatalogsInDataManipulation | false
supportsCatalogsInIndexDefinitions | false
supportsCatalogsInPrivilegeDefinitions | false
supportsCatalogsInProcedureCalls | false
supportsCatalogsInTableDefinitions | false
supportsColumnAliasing | true
supportsConvert | false
supportsCoreSQLGrammar | true
supportsCorrelatedSubqueries | true
supportsDataDefinitionAndDataManipulationTransactions | true
supportsDataManipulationTransactionsOnly | true
supportsDifferentTableCorrelationNames | true
supportsExpressionsInOrderBy | true
supportsExtendedSQLGrammar | true
supportsFullOuterJoins | true
supportsGetGeneratedKeys | true
supportsGroupBy | true
supportsGroupByBeyondSelect | true
supportsGroupByUnrelated | true
supportsIntegrityEnhancementFacility | true
supportsLikeEscapeClause | true
supportsLimitedOuterJoins | true
supportsMinimumSQLGrammar | true
supportsMixedCaseIdentifiers | false
supportsMixedCaseQuotedIdentifiers | true
supportsMultipleOpenResults | false
supportsMultipleResultSets | false
supportsMultipleTransactions | true
supportsNamedParameters | true
supportsNonNullableColumns | true
supportsOpenCursorsAcrossCommit | false
supportsOpenCursorsAcrossRollback | false
supportsOpenStatementsAcrossCommit | false
supportsOpenStatementsAcrossRollback | false
supportsOrderByUnrelated | true
supportsOuterJoins | true
supportsPositionedDelete | false
supportsPositionedUpdate | false
supportsSavepoints | true
supportsSchemasInDataManipulation | true
supportsSchemasInIndexDefinitions | true
supportsSchemasInPrivilegeDefinitions | true
supportsSchemasInProcedureCalls | true
supportsSchemasInTableDefinitions | true
supportsSelectForUpdate | true
supportsStatementPooling | true
supportsStoredProcedures | true
supportsSubqueriesInComparisons | true
supportsSubqueriesInExists | true
supportsSubqueriesInIns | true
supportsSubqueriesInQuantifieds | true
supportsTableCorrelationNames | true
supportsTransactions | true
supportsUnion | true
supportsUnionAll | true
usesLocalFilePerTable | false
usesLocalFiles | false