## Zend_Db_Adapter_Oracle

Description

- license: New BSD License
- copyright: Copyright (c) 2006 Zend Technologies USA Inc. (http://www.zend.com)

Located in /Zend/Db/Adapter/Oracle.php (line 40)

    Zend_Db_Adapter_Abstract
       |
       --Zend_Db_Adapter_Oracle

Variable Summary
array $_config
mixed $_execute_mode
Method Summary
Zend_Db_Adapter_Oracle __construct (array $config)
array describeTable ( $table)
integer lastInsertId ([string $tableName = null], [string $primaryKey = null])
string limit ( $sql, $count, $offset)
array listTables ()
Zend_Db_Statement_Oracle prepare (string $sql)
string quoteIdentifier (string $ident)
void setFetchMode (int $mode)
void _beginTransaction ()
void _commit ()
void _connect ()
void _getExecuteMode ()
string _quote (string $value)
void _rollBack ()
Variables
array $_config = array(
'database' => null,
'username' => null,
'password' => null,
) (line 55)

User-provided configuration.

Basic keys are:

username => (string) Connect to the database as this username. password => (string) Password associated with the username. database => Either the name of the local Oracle instance, or the name of the entry in tnsnames.ora to which you want to connect.

- access: protected
- todo: fix inconsistency between "database" used here and "dbname" use elsewhere

Redefinition of:

Zend_Db_Adapter_Abstract::$_config
  User-provided configuration

mixed $_execute_mode = OCI_COMMIT_ON_SUCCESS (line 61)

- access: protected

#### Inherited Variables

Inherited from Zend_Db_Adapter_Abstract

> Zend_Db_Adapter_Abstract::$_connection
> Zend_Db_Adapter_Abstract::$_fetchMode
> Zend_Db_Adapter_Abstract::$_profiler

Methods
Constructor __construct (line 76)

Constructor.

$config is an array of key/value pairs containing configuration options. These options are common to most adapters:

username => (string) Connect to the database as this username. password => (string) Password associated with the username. database => Either the name of the local Oracle instance, or the name of the entry in tnsnames.ora to which you want to connect.

- access: public

Zend_Db_Adapter_Oracle __construct (array $config)

- array $config: An array of configuration keys.

Redefinition of:

Zend_Db_Adapter_Abstract::__construct()
  Constructor.

describeTable (line 176)

Returns the column descriptions for a table.

- access: public

array describeTable ( $table)

- $table

Redefinition of:

Zend_Db_Adapter_Abstract::describeTable()
  Returns the column descriptions for a table.

lastInsertId (line 149)

Gets the last inserted ID.

- access: public

integer lastInsertId ([string $tableName = null], [string $primaryKey = null])

- string $tableName: name of table associated with sequence
- string $primaryKey: not used in this adapter

Redefinition of:

Zend_Db_Adapter_Abstract::lastInsertId()
  Gets the last inserted ID.

limit (line 281)

Adds an adapter-specific LIMIT clause to the SELECT statement.

- access: public

string limit ( $sql, $count, $offset)

- $sql
- $count
- $offset

Redefinition of:

Zend_Db_Adapter_Abstract::limit()
  Adds an adapter-specific LIMIT clause to the SELECT statement.

listTables (line 164)

Returns a list of the tables in the database.

- access: public

array listTables ()

Redefinition of:

Zend_Db_Adapter_Abstract::listTables()
  Returns a list of the tables in the database.

prepare (line 134)

Returns an SQL statement for preparation.

- access: public

Zend_Db_Statement_Oracle prepare (string $sql)

- string $sql: The SQL statement with placeholders.

Redefinition of:

Zend_Db_Adapter_Abstract::prepare()
  Prepare a statement and return a PDOStatement-like object.

quoteIdentifier (line 269)

Quotes an identifier.

- return: The quoted identifier.
- access: public

string quoteIdentifier (string $ident)

- string $ident: The identifier.

Redefinition of:

Zend_Db_Adapter_Abstract::quoteIdentifier()
  Quotes an identifier.

setFetchMode (line 234)

Set the fetch mode.

- access: public
- todo: Support FETCH_CLASS and FETCH_INTO.

void setFetchMode (int $mode)

- int $mode: A fetch mode.

Redefinition of:

Zend_Db_Adapter_Abstract::setFetchMode()
  Set the fetch mode.

_beginTransaction (line 196)

Leave autocommit mode and begin a transaction.

- access: protected

void _beginTransaction ()

Redefinition of:

Zend_Db_Adapter_Abstract::_beginTransaction()
  Begin a transaction.

_commit (line 205)

Commit a transaction and return to autocommit mode.

- access: protected

void _commit ()

Redefinition of:

Zend_Db_Adapter_Abstract::_commit()
  Commit a transaction.

_connect (line 106)

Creates a connection resource.

- access: protected

void _connect ()

Redefinition of:

Zend_Db_Adapter_Abstract::_connect()
  Creates a connection to the database.

_getExecuteMode (line 319)

- access: public

void _getExecuteMode ()
_quote (line 256)

Quote a raw string.

- return: Quoted string
- access: protected

string _quote (string $value)

- string $value: Raw string

Redefinition of:

Zend_Db_Adapter_Abstract::_quote()
  Quote a raw string.

_rollBack (line 218)

Roll back a transaction and return to autocommit mode.

- access: protected

void _rollBack ()

Redefinition of:

Zend_Db_Adapter_Abstract::_rollBack()
  Roll-back a transaction.

#### Inherited Methods

Inherited From Zend_Db_Adapter_Abstract

> Zend_Db_Adapter_Abstract::__construct()
> Zend_Db_Adapter_Abstract::beginTransaction()
> Zend_Db_Adapter_Abstract::commit()
> Zend_Db_Adapter_Abstract::delete()
> Zend_Db_Adapter_Abstract::describeTable()
> Zend_Db_Adapter_Abstract::fetchAll()
> Zend_Db_Adapter_Abstract::fetchAssoc()
> Zend_Db_Adapter_Abstract::fetchCol()
> Zend_Db_Adapter_Abstract::fetchOne()
> Zend_Db_Adapter_Abstract::fetchPairs()
> Zend_Db_Adapter_Abstract::fetchRow()
> Zend_Db_Adapter_Abstract::getConnection()
> Zend_Db_Adapter_Abstract::getFetchMode()
> Zend_Db_Adapter_Abstract::getProfiler()
> Zend_Db_Adapter_Abstract::insert()
> Zend_Db_Adapter_Abstract::lastInsertId()
> Zend_Db_Adapter_Abstract::limit()
> Zend_Db_Adapter_Abstract::listTables()
> Zend_Db_Adapter_Abstract::prepare()
> Zend_Db_Adapter_Abstract::query()
> Zend_Db_Adapter_Abstract::quote()
> Zend_Db_Adapter_Abstract::quoteIdentifier()
> Zend_Db_Adapter_Abstract::quoteInto()
> Zend_Db_Adapter_Abstract::rollBack()
> Zend_Db_Adapter_Abstract::select()
> Zend_Db_Adapter_Abstract::setFetchMode()
> Zend_Db_Adapter_Abstract::update()
> Zend_Db_Adapter_Abstract::_beginTransaction()
> Zend_Db_Adapter_Abstract::_commit()
> Zend_Db_Adapter_Abstract::_connect()
> Zend_Db_Adapter_Abstract::_quote()
> Zend_Db_Adapter_Abstract::_rollBack()

Documentation generated on Tue, 11 Jul 2006 12:17:50 -0500 by phpDocumentor 1.3.0RC6