Class JDatabaseDriverOracle

Oracle database driver

JDatabase

JDatabaseDriver implements JDatabaseInterface

JDatabaseDriverOracle

Package: Joomla\Platform\Database
Copyright: Copyright (C) 2005 - 2017 Open Source Matters, Inc. All rights reserved.
License: General Public License version 2 or later; see LICENSE
Since: 12.1
Link: https://secure.php.net/pdo
Located at joomla/database/driver/oracle.php

Methods summary

`public`	# `__construct( array $options )` Constructor. Constructor. Parameters `$options` `array` - $options List of options used to configure the connection Since 12.1 Overrides `JDatabaseDriverPdo::__construct`
`public`	# `__destruct( )` Destructor. Destructor. Since 12.1 Overrides `JDatabaseDriverPdo::__destruct`
`public`	# `connect( )` Connects to the database if needed. Connects to the database if needed. Returns - Returns void if the database connected successfully. Throws `RuntimeException` Since 12.1 Overrides `JDatabaseDriverPdo::connect`
`public`	# `disconnect( )` Disconnects the database. Disconnects the database. Since 12.1 Overrides `JDatabaseDriverPdo::disconnect`
`public JDatabaseDriverOracle`	# `dropTable( string $tableName, boolean $ifExists = true )` Drops a table from the database. Drops a table from the database. Note: The IF EXISTS flag is unused in the Oracle driver. Parameters `$tableName` `string` - $tableName The name of the database table to drop. `$ifExists` `boolean` - $ifExists Optionally specify that the table must exist before it is dropped. Returns `JDatabaseDriverOracle` - Returns this object to support chaining. Throws `RuntimeException` Since 12.1
`public mixed`	# `getCollation( )` Method to get the database collation in use by sampling a text field of a table in the database. Method to get the database collation in use by sampling a text field of a table in the database. Returns `mixed` - The collation in use by the database or boolean false if not supported. Since 12.1
`public string`	# `getConnectionCollation( )` Method to get the database connection collation, as reported by the driver. If the connector doesn't support reporting this value please return an empty string. Method to get the database connection collation, as reported by the driver. If the connector doesn't support reporting this value please return an empty string. Returns `string` Overrides `JDatabaseDriver::getConnectionCollation`
`public string`	# `getConnectedQuery( )` Get a query to run and verify the database is operational. Get a query to run and verify the database is operational. Returns `string` - The query to check the health of the DB. Since 12.2 Overrides `JDatabaseDriverPdo::getConnectedQuery`
`public string`	# `getDateFormat( )` Returns the current date format This method should be useful in the case that somebody actually wants to use a different date format and needs to check what the current one is to see if it needs to be changed. Returns the current date format This method should be useful in the case that somebody actually wants to use a different date format and needs to check what the current one is to see if it needs to be changed. Returns `string` - The current date format Since 12.1 Overrides `JDatabaseDriver::getDateFormat`
`public array`	# `getTableCreate( mixed $tables )` Shows the table CREATE statement that creates the given tables. Shows the table CREATE statement that creates the given tables. Note: You must have the correct privileges before this method will return usable results! Parameters `$tables` `mixed` - $tables A table name or a list of table names. Returns `array` - A list of the create SQL for the tables. Throws `RuntimeException` Since 12.1
`public array`	# `getTableColumns( string $table, boolean $typeOnly = true )` Retrieves field information about a given table. Retrieves field information about a given table. Parameters `$table` `string` - $table The name of the database table. `$typeOnly` `boolean` - $typeOnly True to only return field types. Returns `array` - An array of fields for the database table. Throws `RuntimeException` Since 12.1
`public array`	# `getTableKeys( string $table )` Get the details list of keys for a table. Get the details list of keys for a table. Parameters `$table` `string` - $table The name of the table. Returns `array` - An array of the column specification for the table. Throws `RuntimeException` Since 12.1
`public array`	# `getTableList( string $databaseName = null, boolean $includeDatabaseName = false )` Method to get an array of all tables in the database (schema). Method to get an array of all tables in the database (schema). Parameters `$databaseName` `string` - $databaseName The database (schema) name `$includeDatabaseName` `boolean` - $includeDatabaseName Whether to include the schema name in the results Returns `array` - An array of all the tables in the database. Throws `RuntimeException` Since 12.1
`public string`	# `getVersion( )` Get the version of the database connector. Get the version of the database connector. Returns `string` - The database connector version. Since 12.1
`public boolean`	# `select( string $database )` Select a database for use. Select a database for use. Parameters `$database` `string` - $database The name of the database to select for use. Returns `boolean` - True if the database was successfully selected. Throws `RuntimeException` Since 12.1 Overrides `JDatabaseDriverPdo::select`
`public boolean`	# `setDateFormat( string $dateFormat = 'DD-MON-RR' )` Sets the Oracle Date Format for the session Default date format for Oracle is = DD-MON-RR The default date format for this driver is: 'RRRR-MM-DD HH24:MI:SS' since it is the format that matches the MySQL one used within most Joomla tables. Sets the Oracle Date Format for the session Default date format for Oracle is = DD-MON-RR The default date format for this driver is: 'RRRR-MM-DD HH24:MI:SS' since it is the format that matches the MySQL one used within most Joomla tables. Parameters `$dateFormat` `string` - $dateFormat Oracle Date Format String Returns `boolean` Since 12.1
`public boolean`	# `setUtf( )` Set the connection to use UTF-8 character encoding. Set the connection to use UTF-8 character encoding. Returns false automatically for the Oracle driver since you can only set the character set when the connection is created. Returns `boolean` - True on success. Since 12.1 Overrides `JDatabaseDriverPdo::setUtf`
`public JDatabaseDriverOracle`	# `lockTable( string $table )` Locks a table in the database. Locks a table in the database. Parameters `$table` `string` - $table The name of the table to unlock. Returns `JDatabaseDriverOracle` - Returns this object to support chaining. Throws `RuntimeException` Since 12.1
`public JDatabaseDriverOracle`	# `renameTable( string $oldTable, string $newTable, string $backup = null, string $prefix = null )` Renames a table in the database. Renames a table in the database. Parameters `$oldTable` `string` - $oldTable The name of the table to be renamed `$newTable` `string` - $newTable The new name for the table. `$backup` `string` - $backup Not used by Oracle. `$prefix` `string` - $prefix Not used by Oracle. Returns `JDatabaseDriverOracle` - Returns this object to support chaining. Throws `RuntimeException` Since 12.1
`public JDatabaseDriverOracle`	# `unlockTables( )` Unlocks tables in the database. Unlocks tables in the database. Returns `JDatabaseDriverOracle` - Returns this object to support chaining. Throws `RuntimeException` Since 12.1
`public static boolean`	# `isSupported( )` Test to see if the PDO ODBC connector is available. Test to see if the PDO ODBC connector is available. Returns `boolean` - True on success, false otherwise. Since 12.1 Overrides `JDatabaseDriverPdo::isSupported`
`public string`	# `replacePrefix( string $query, string $prefix = '#__' )` This function replaces a string identifier `$prefix` with the string held is the `tablePrefix` class variable. This function replaces a string identifier `$prefix` with the string held is the `tablePrefix` class variable. Parameters `$query` `string` - $query The SQL statement to prepare. `$prefix` `string` - $prefix The common table prefix. Returns `string` - The processed SQL statement. Since 11.1 Overrides `JDatabaseDriver::replacePrefix`
`public`	# `transactionCommit( boolean $toSavepoint = false )` Method to commit a transaction. Method to commit a transaction. Parameters `$toSavepoint` `boolean` - $toSavepoint If true, commit to the last savepoint. Throws `RuntimeException` Since 12.3 Overrides `JDatabaseDriverPdo::transactionCommit`
`public`	# `transactionRollback( boolean $toSavepoint = false )` Method to roll back a transaction. Method to roll back a transaction. Parameters `$toSavepoint` `boolean` - $toSavepoint If true, rollback to the last savepoint. Throws `RuntimeException` Since 12.3 Overrides `JDatabaseDriverPdo::transactionRollback`
`public`	# `transactionStart( boolean $asSavepoint = false )` Method to initialize a transaction. Method to initialize a transaction. Parameters `$asSavepoint` `boolean` - $asSavepoint If true and a transaction is already active, a savepoint will be created. Throws `RuntimeException` Since 12.3 Overrides `JDatabaseDriverPdo::transactionStart`
`public string[]`	# `getAlterTableCharacterSet( string $tableName )` Get the query strings to alter the character set and collation of a table. Get the query strings to alter the character set and collation of a table. Parameters `$tableName` `string` - $tableName The name of the table Returns `string[]` - The queries required to alter the table's character set and collation Since CMS 3.5.0 Overrides `JDatabaseDriver::getAlterTableCharacterSet`
`protected string`	# `getCreateDatabaseQuery( stdClass $options, boolean $utf )` Return the query string to create new Database. Each database driver, other than MySQL, need to override this member to return correct string. Return the query string to create new Database. Each database driver, other than MySQL, need to override this member to return correct string. Parameters `$options` `stdClass` - $options Object used to pass user and database name to database driver. This object must have "db_name" and "db_user" set. `$utf` `boolean` - $utf True if the database supports the UTF-8 character set. Returns `string` - The query that creates database Since 12.2 Overrides `JDatabaseDriver::getCreateDatabaseQuery`

Magic methods summary

Magic methods inherited from JDatabaseDriver

q(), qn()

Properties summary

`public string`	`$name`	# The name of the database driver. The name of the database driver. Since 12.1
`public string`	`$serverType`	# The type of the database server family supported by this driver. The type of the database server family supported by this driver. Since CMS 3.5.0
`protected string`	`$nameQuote`	# The character(s) used to quote SQL statement names such as table names or field names, etc. The child classes should define this as necessary. If a single character string the same character is used for both sides of the quoted name, else the first character will be used for the opening quote and the second for the closing quote. The character(s) used to quote SQL statement names such as table names or field names, etc. The child classes should define this as necessary. If a single character string the same character is used for both sides of the quoted name, else the first character will be used for the opening quote and the second for the closing quote. Since 12.1
`protected string`	`$dateformat`	# Returns the current dateformat Returns the current dateformat Since 12.1
`protected string`	`$charset`	# Returns the current character set Returns the current character set Since 12.1

Properties inherited from JDatabaseDriverPdo

$connection, $executed, $nullDate, $prepared

Properties inherited from JDatabaseDriver

$callStacks, $count, $cursor, $dbMinimum, $debug, $disconnectHandlers, $errorMsg, $errorNum, $instances, $limit, $log, $offset, $options, $sql, $tablePrefix, $timings, $transactionDepth, $utf, $utf8mb4

Namespaces

Classes

Interfaces

Exceptions

Constants

Functions

Class JDatabaseDriverOracle

Methods summary

Parameters

Since

Overrides

Since

Overrides

Returns

Throws

Since

Overrides

Since

Overrides

Parameters

Returns

Throws

Since

Returns

Since

Returns

Overrides

Returns

Since

Overrides

Returns

Since

Overrides

Parameters

Returns

Throws

Since

Parameters

Returns

Throws

Since

Parameters

Returns

Throws

Since

Parameters

Returns

Throws

Since

Returns

Since

Parameters

Returns

Throws

Since

Overrides

Parameters

Returns

Since

Returns

Since

Overrides

Parameters

Returns

Throws

Since

Parameters

Returns

Throws

Since

Returns

Throws

Since

Returns

Since

Overrides

Parameters

Returns

Since

Overrides