Inheritance diagram for ADODB_oci8:

Public Member Functions
	ADODB_oci8 ()

	MetaColumns ($table, $normalize=true)

	Time ()

	_connect ($argHostname, $argUsername, $argPassword, $argDatabasename=null, $mode=0)

	ServerInfo ()

	_pconnect ($argHostname, $argUsername, $argPassword, $argDatabasename)

	_nconnect ($argHostname, $argUsername, $argPassword, $argDatabasename)

	_affectedrows ()

	IfNull ( $field, $ifNull)

	DBDate ($d, $isfld=false)

	BindDate ($d)

	BindTimeStamp ($ts)

	DBTimeStamp ($ts, $isfld=false)

	RowLock ($tables, $where, $col='1 as adodbignore')

	MetaTables ($ttype=false, $showSchema=false, $mask=false)

	MetaIndexes ($table, $primary=FALSE, $owner=false)

	BeginTrans ()

	CommitTrans ($ok=true)

	RollbackTrans ()

	SelectDB ($dbName)

	ErrorMsg ()

	ErrorNo ()

	SQLDate ($fmt, $col=false)

	GetRandRow ($sql, $arr=false)

	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)

	UpdateBlob ($table, $column, $val, $where, $blobtype='BLOB')

	UpdateBlobFile ($table, $column, $val, $where, $blobtype='BLOB')

	Execute ($sql, $inputarr=false)

	Prepare ($sql, $cursor=false)

	ExecuteCursor ($sql, $cursorName='rs', $params=false)

	Bind (&$stmt, &$var, $size=4000, $type=false, $name=false, $isOutput=false)

	Param ($name, $type='C')

	Parameter (&$stmt, &$var, $name, $isOutput=false, $maxLen=4000, $type=false)

	_query ($sql, $inputarr=false)

	IsConnectionError ($err)

	_close ()

	MetaPrimaryKeys ($table, $owner=false, $internalKey=false)

	MetaForeignKeys ($table, $owner=false, $upper=false)

	CharMax ()

	TextMax ()

	qstr ($s, $magic_quotes=false)

Public Attributes
	$databaseType = 'oci8'

	$dataProvider = 'oci8'

	$replaceQuote = "''"

	$concat_operator ='\|\|'

	$sysDate = "TRUNC(SYSDATE)"

	$sysTimeStamp = 'SYSDATE'

	$metaDatabasesSQL = "SELECT USERNAME FROM ALL_USERS WHERE USERNAME NOT IN ('SYS','SYSTEM','DBSNMP','OUTLN') ORDER BY 1"

	$_stmt

	$_commit = OCI_COMMIT_ON_SUCCESS

	$_initdate = true

	$metaTablesSQL = "select table_name,table_type from cat where table_type in ('TABLE','VIEW') and table_name not like 'BIN\$%'"

	$metaColumnsSQL = "select cname,coltype,width, SCALE, PRECISION, NULLS, DEFAULTVAL from col where tname='%s' order by colno"

	$metaColumnsSQL2

	$_bindInputArray = true

	$hasGenID = true

	$_genIDSQL = "SELECT (%s.nextval) FROM DUAL"

	$_genSeqSQL

	$_dropSeqSQL = "DROP SEQUENCE %s"

	$hasAffectedRows = true

	$random = "abs(mod(DBMS_RANDOM.RANDOM,10000001)/10000000)"

	$noNullStrings = false

	$connectSID = false

	$_bind = false

	$_nestedSQL = true

	$_hasOciFetchStatement = false

	$_getarray = false

	$leftOuter = ''

	$session_sharing_force_blob = false

	$firstrows = true

	$selectOffsetAlg1 = 1000

	$NLS_DATE_FORMAT = 'YYYY-MM-DD'

	$dateformat = 'YYYY-MM-DD'

	$useDBDateFormatForTextInput =false

	$datetime = false

	$_refLOBs = array()

Detailed Description

Definition at line 55 of file adodb-oci8.inc.php.

Member Function Documentation

◆ _affectedrows()

ADODB_oci8::_affectedrows ( )

Definition at line 276 of file adodb-oci8.inc.php.

◆ _close()

ADODB_oci8::_close ( )

Definition at line 1199 of file adodb-oci8.inc.php.

◆ _connect()

ADODB_oci8::_connect	(	$argHostname,
		$argUsername,
		$argPassword,
		$argDatabasename = `null`,
		$mode = `0`
	)

Multiple modes of connection are supported:

a. Local Database $conn->Connect(false,'scott','tiger');

b. From tnsnames.ora $conn->Connect($tnsname,'scott','tiger'); $conn->Connect(false,'scott','tiger',$tnsname);

c. Server + service name $conn->Connect($serveraddress,'scott,'tiger',$service_name);

d. Server + SID $conn->connectSID = true; $conn->Connect($serveraddress,'scott,'tiger',$SID);

Parameters

string \| false	$argHostname	DB server hostname or TNS name
string	$argUsername
string	$argPassword
string	$argDatabasename	Service name, SID (defaults to null)
int	$mode	Connection mode, defaults to 0 (0 = non-persistent, 1 = persistent, 2 = force new connection)

Returns: bool

Definition at line 194 of file adodb-oci8.inc.php.

References Execute().

Referenced by _nconnect(), and _pconnect().

◆ _nconnect()

ADODB_oci8::_nconnect	(	$argHostname,
		$argUsername,
		$argPassword,
		$argDatabasename
	)

Definition at line 271 of file adodb-oci8.inc.php.

References _connect().

◆ _pconnect()

ADODB_oci8::_pconnect	(	$argHostname,
		$argUsername,
		$argPassword,
		$argDatabasename
	)

Definition at line 265 of file adodb-oci8.inc.php.

References _connect().

◆ _query()

ADODB_oci8::_query	(	$sql,
		$inputarr = `false`
	)

returns query ID if successful, otherwise false this version supports:

$db->execute('select * from table');
$db->prepare('insert into table (a,b,c) values (:0,:1,:2)'); $db->execute($prepared_statement, array(1,2,3));
$db->execute('insert into table (a,b,c) values (:a,:b,:c)',array('a'=>1,'b'=>2,'c'=>3));
$db->prepare('insert into table (a,b,c) values (:0,:1,:2)'); $db->bind($stmt,1); $db->bind($stmt,2); $db->bind($stmt,3); $db->execute($stmt);

Definition at line 1060 of file adodb-oci8.inc.php.

References $sql, and debug().

Referenced by ADODB_oci8po\_query().

◆ ADODB_oci8()

ADODB_oci8::ADODB_oci8 ( )

Definition at line 105 of file adodb-oci8.inc.php.

Referenced by ADODB_oci805\ADODB_oci805().

◆ BeginTrans()

ADODB_oci8::BeginTrans ( )

Definition at line 432 of file adodb-oci8.inc.php.

References Execute().

Referenced by RowLock(), UpdateBlob(), and UpdateBlobFile().

◆ Bind()

ADODB_oci8::Bind	(	&	$stmt,
		&	$var,
			$size = `4000`,
			$type = `false`,
			$name = `false`,
			$isOutput = `false`
	)

Bind a variable – very, very fast for executing repeated statements in oracle.

Better than using for ($i = 0; $i < $max; $i++) { $p1 = ?; $p2 = ?; $p3 = ?; $this->Execute("insert into table (col0, col1, col2) values (:0, :1, :2)", array($p1,$p2,$p3)); }

Usage: $stmt = $DB->Prepare("insert into table (col0, col1, col2) values (:0, :1, :2)"); $DB->Bind($stmt, $p1); $DB->Bind($stmt, $p2); $DB->Bind($stmt, $p3); for ($i = 0; $i < $max; $i++) { $p1 = ?; $p2 = ?; $p3 = ?; $DB->Execute($stmt); }

Some timings to insert 1000 records, test table has 3 cols, and 1 index.

Time 0.6081s (1644.60 inserts/sec) with direct oci_parse/oci_execute
Time 0.6341s (1577.16 inserts/sec) with ADOdb Prepare/Bind/Execute
Time 1.5533s ( 643.77 inserts/sec) with pure SQL using Execute

Now if PHP only had batch/bulk updating like Java or PL/SQL...

Note that the order of parameters differs from oci_bind_by_name, because we default the names to :0, :1, :2

Definition at line 963 of file adodb-oci8.inc.php.

References debug(), and oci_lob_desc().

Referenced by Parameter().

◆ BindDate()

ADODB_oci8::BindDate ( $d )

Definition at line 305 of file adodb-oci8.inc.php.

◆ BindTimeStamp()

ADODB_oci8::BindTimeStamp ( $ts )

Definition at line 313 of file adodb-oci8.inc.php.

References adodb_date().

◆ CharMax()

ADODB_oci8::CharMax ( )

Definition at line 1300 of file adodb-oci8.inc.php.

◆ CommitTrans()

ADODB_oci8::CommitTrans ( $ok = true )

Definition at line 445 of file adodb-oci8.inc.php.

References RollbackTrans().

Referenced by UpdateBlob(), and UpdateBlobFile().

◆ DBDate()

ADODB_oci8::DBDate	(	$d,
		$isfld = `false`
	)

Definition at line 288 of file adodb-oci8.inc.php.

References adodb_date().

◆ DBTimeStamp()

ADODB_oci8::DBTimeStamp	(	$ts,
		$isfld = `false`
	)

Definition at line 325 of file adodb-oci8.inc.php.

◆ ErrorMsg()

ADODB_oci8::ErrorMsg ( )

Definition at line 473 of file adodb-oci8.inc.php.

◆ ErrorNo()

ADODB_oci8::ErrorNo ( )

Definition at line 488 of file adodb-oci8.inc.php.

◆ Execute()

ADODB_oci8::Execute	(	$sql,
		$inputarr = `false`
	)

Execute SQL

Parameters

sql	SQL statement to execute, or possibly an array holding prepared statement ($sql[0] will hold sql text)
[inputarr]	holds the input data to bind to. Null elements will be set to null.

Returns: RecordSet or false

Definition at line 793 of file adodb-oci8.inc.php.

References $sql, Prepare(), and qstr().

Referenced by _connect(), BeginTrans(), ExecuteCursor(), MetaColumns(), MetaIndexes(), MetaPrimaryKeys(), SelectLimit(), Time(), UpdateBlob(), and UpdateBlobFile().

◆ ExecuteCursor()

ADODB_oci8::ExecuteCursor	(	$sql,
		$cursorName = `'rs'`,
		$params = `false`
	)

Definition at line 909 of file adodb-oci8.inc.php.

References $rs, $sql, Execute(), Parameter(), and Prepare().

◆ GetRandRow()

ADODB_oci8::GetRandRow	(	$sql,
		$arr = `false`
	)

Definition at line 585 of file adodb-oci8.inc.php.

References $sql.

◆ IfNull()

ADODB_oci8::IfNull	(	$field,
		$ifNull
	)

Definition at line 282 of file adodb-oci8.inc.php.

◆ IsConnectionError()

ADODB_oci8::IsConnectionError ( $err )

Definition at line 1173 of file adodb-oci8.inc.php.

◆ MetaColumns()

ADODB_oci8::MetaColumns	(	$table,
		$normalize = `true`
	)

Definition at line 112 of file adodb-oci8.inc.php.

References $rs, and Execute().

◆ MetaForeignKeys()

ADODB_oci8::MetaForeignKeys	(	$table,
		$owner = `false`,
		$upper = `false`
	)

returns assoc array where keys are tables, and values are foreign keys

Parameters

str	$table
str	$owner	[optional][default=NULL]
bool	$upper	[optional][discarded]

Returns: mixed[] Array of foreign key information

http://gis.mit.edu/classes/11.521/sqlnotes/referential_integrity.html

Definition at line 1260 of file adodb-oci8.inc.php.

References $sql, and qstr().

◆ MetaIndexes()

ADODB_oci8::MetaIndexes	(	$table,
		$primary = `FALSE`,
		$owner = `false`
	)

Definition at line 359 of file adodb-oci8.inc.php.

References $rs, and Execute().

◆ MetaPrimaryKeys()

ADODB_oci8::MetaPrimaryKeys	(	$table,
		$owner = `false`,
		$internalKey = `false`
	)

Definition at line 1216 of file adodb-oci8.inc.php.

References $rs, $sql, and Execute().

◆ MetaTables()

ADODB_oci8::MetaTables	(	$ttype = `false`,
		$showSchema = `false`,
		$mask = `false`
	)

Definition at line 343 of file adodb-oci8.inc.php.

References $metaTablesSQL, and qstr().

◆ Param()

ADODB_oci8::Param	(	$name,
		$type = `'C'`
	)

Definition at line 1014 of file adodb-oci8.inc.php.

◆ Parameter()

ADODB_oci8::Parameter	(	&	$stmt,
		&	$var,
			$name,
			$isOutput = `false`,
			$maxLen = `4000`,
			$type = `false`
	)

Usage: $stmt = $db->Prepare('select * from table where id =:myid and group=:group'); $db->Parameter($stmt,$id,'myid'); $db->Parameter($stmt,$group,'group'); $db->Execute($stmt);

Parameters

$stmt	Statement returned by Prepare() or PrepareSP().
$var	PHP variable to bind to
$name	Name of stored procedure variable name to bind to.
[$isOutput]	Indicates direction of parameter 0/false=IN 1=OUT 2= IN/OUT. This is ignored in oci8.
[$maxLen]	Holds an maximum length of the variable.
[$type]	The data type of $var. Legal values depend on driver.

http://php.net/oci_bind_by_name

Definition at line 1035 of file adodb-oci8.inc.php.

References Bind(), and debug().

Referenced by ExecuteCursor().

◆ Prepare()

ADODB_oci8::Prepare	(	$sql,
		$cursor = `false`
	)

Definition at line 869 of file adodb-oci8.inc.php.

References $sql.

Referenced by Execute(), ExecuteCursor(), ADODB_oci8po\Prepare(), and SelectLimit().

◆ qstr()

ADODB_oci8::qstr	(	$s,
		$magic_quotes = `false`
	)

Quotes a string. An example is $db->qstr("Don't bother",magic_quotes_runtime());

Parameters

string	$s	the string to quote
bool	$magic_quotes	if $s is GET/POST var, set to get_magic_quotes_gpc(). This undoes the stupidity of magic quotes for GPC.

Returns: string quoted string to be sent back to database

Definition at line 1320 of file adodb-oci8.inc.php.

Referenced by Execute(), MetaForeignKeys(), and MetaTables().

◆ RollbackTrans()

ADODB_oci8::RollbackTrans ( )

Definition at line 457 of file adodb-oci8.inc.php.

Referenced by CommitTrans().

◆ RowLock()

ADODB_oci8::RowLock	(	$tables,
		$where,
		$col = `'1 as adodbignore'`
	)

Definition at line 337 of file adodb-oci8.inc.php.

References BeginTrans().

◆ SelectDB()

ADODB_oci8::SelectDB ( $dbName )

Definition at line 468 of file adodb-oci8.inc.php.

◆ SelectLimit()

ADODB_oci8::SelectLimit	(	$sql,
		$nrows = `-1`,
		$offset = `-1`,
		$inputarr = `false`,
		$secs2cache = `0`
	)

This algorithm makes use of

a. FIRST_ROWS hint The FIRST_ROWS hint explicitly chooses the approach to optimize response time, that is, minimum resource usage to return the first row. Results will be returned as soon as they are identified.

b. Uses rownum tricks to obtain only the required rows from a given offset. As this uses complicated sql statements, we only use this if $offset >= 100. This idea by Tomas V V Cox.

This implementation does not appear to work with oracle 8.0.5 or earlier. Comment out this function then, and the slower SelectLimit() in the base class will be used.

Definition at line 608 of file adodb-oci8.inc.php.

References $result, $rs, $sql, Execute(), and Prepare().

◆ ServerInfo()

ADODB_oci8::ServerInfo ( )

Definition at line 257 of file adodb-oci8.inc.php.

◆ SQLDate()

ADODB_oci8::SQLDate	(	$fmt,
		$col = `false`
	)

Format date column in sql string given an input format that understands Y M D

Definition at line 508 of file adodb-oci8.inc.php.

References $sysTimeStamp.

◆ TextMax()

ADODB_oci8::TextMax ( )

Definition at line 1305 of file adodb-oci8.inc.php.

◆ Time()

ADODB_oci8::Time ( )

Definition at line 160 of file adodb-oci8.inc.php.

References $rs, and Execute().

◆ UpdateBlob()

ADODB_oci8::UpdateBlob	(	$table,
		$column,
		$val,
		$where,
		$blobtype = `'BLOB'`
	)

Usage: Store BLOBs and CLOBs

Example: to store $var in a blob $conn->Execute('insert into TABLE (id,ablob) values(12,empty_blob())'); $conn->UpdateBlob('TABLE', 'ablob', $varHoldingBlob, 'ID=12', 'BLOB');

$blobtype supports 'BLOB' and 'CLOB', but you need to change to 'empty_clob()'.

to get length of LOB: select DBMS_LOB.GETLENGTH(ablob) from TABLE

If you are using CURSOR_SHARING = force, it appears this will case a segfault under oracle 8.1.7.0. Run: $db->Execute('ALTER SESSION SET CURSOR_SHARING=EXACT'); before UpdateBlob() then...

Definition at line 726 of file adodb-oci8.inc.php.

References $rs, $sql, BeginTrans(), CommitTrans(), and Execute().

◆ UpdateBlobFile()

ADODB_oci8::UpdateBlobFile	(	$table,
		$column,
		$val,
		$where,
		$blobtype = `'BLOB'`
	)

Usage: store file pointed to by $val in a blob

Definition at line 760 of file adodb-oci8.inc.php.

References $rs, $sql, BeginTrans(), CommitTrans(), and Execute().

Member Data Documentation

◆ $_bind

ADODB_oci8::$_bind = false

Definition at line 89 of file adodb-oci8.inc.php.

◆ $_bindInputArray

ADODB_oci8::$_bindInputArray = true

Definition at line 73 of file adodb-oci8.inc.php.

◆ $_commit

ADODB_oci8::$_commit = OCI_COMMIT_ON_SUCCESS

Definition at line 64 of file adodb-oci8.inc.php.

◆ $_dropSeqSQL

ADODB_oci8::$_dropSeqSQL = "DROP SEQUENCE %s"

Definition at line 84 of file adodb-oci8.inc.php.

◆ $_genIDSQL

ADODB_oci8::$_genIDSQL = "SELECT (%s.nextval) FROM DUAL"

Definition at line 75 of file adodb-oci8.inc.php.

◆ $_genSeqSQL

ADODB_oci8::$_genSeqSQL

Initial value:

= "
DECLARE
    PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
    execute immediate 'CREATE SEQUENCE %s START WITH %s';
END;
"

Definition at line 76 of file adodb-oci8.inc.php.

◆ $_getarray

ADODB_oci8::$_getarray = false

Definition at line 92 of file adodb-oci8.inc.php.

◆ $_hasOciFetchStatement

ADODB_oci8::$_hasOciFetchStatement = false

Definition at line 91 of file adodb-oci8.inc.php.

◆ $_initdate

ADODB_oci8::$_initdate = true

Definition at line 65 of file adodb-oci8.inc.php.

◆ $_nestedSQL

ADODB_oci8::$_nestedSQL = true

Definition at line 90 of file adodb-oci8.inc.php.

◆ $_refLOBs

ADODB_oci8::$_refLOBs = array()

Definition at line 101 of file adodb-oci8.inc.php.

◆ $_stmt

ADODB_oci8::$_stmt

Definition at line 63 of file adodb-oci8.inc.php.

◆ $concat_operator

ADODB_oci8::$concat_operator ='||'

Definition at line 59 of file adodb-oci8.inc.php.

◆ $connectSID

ADODB_oci8::$connectSID = false

Definition at line 88 of file adodb-oci8.inc.php.

◆ $databaseType

ADODB_oci8::$databaseType = 'oci8'

Definition at line 56 of file adodb-oci8.inc.php.

◆ $dataProvider

ADODB_oci8::$dataProvider = 'oci8'

Definition at line 57 of file adodb-oci8.inc.php.

◆ $dateformat

ADODB_oci8::$dateformat = 'YYYY-MM-DD'

Definition at line 98 of file adodb-oci8.inc.php.

◆ $datetime

ADODB_oci8::$datetime = false

Definition at line 100 of file adodb-oci8.inc.php.

◆ $firstrows

ADODB_oci8::$firstrows = true

Definition at line 95 of file adodb-oci8.inc.php.

◆ $hasAffectedRows

ADODB_oci8::$hasAffectedRows = true

Definition at line 85 of file adodb-oci8.inc.php.

◆ $hasGenID

ADODB_oci8::$hasGenID = true

Definition at line 74 of file adodb-oci8.inc.php.

◆ $leftOuter

ADODB_oci8::$leftOuter = ''

Definition at line 93 of file adodb-oci8.inc.php.

◆ $metaColumnsSQL

ADODB_oci8::$metaColumnsSQL = "select cname,coltype,width, SCALE, PRECISION, NULLS, DEFAULTVAL from col where tname='%s' order by colno"

Definition at line 67 of file adodb-oci8.inc.php.

◆ $metaColumnsSQL2

ADODB_oci8::$metaColumnsSQL2

Initial value:

= "select column_name,data_type,data_length, data_scale, data_precision,
    case when nullable = 'Y' then 'NULL'
    else 'NOT NULL' end as nulls,
    data_default from all_tab_cols
  where owner='%s' and table_name='%s' order by column_id"

Definition at line 68 of file adodb-oci8.inc.php.

◆ $metaDatabasesSQL

ADODB_oci8::$metaDatabasesSQL = "SELECT USERNAME FROM ALL_USERS WHERE USERNAME NOT IN ('SYS','SYSTEM','DBSNMP','OUTLN') ORDER BY 1"

Definition at line 62 of file adodb-oci8.inc.php.

◆ $metaTablesSQL

ADODB_oci8::$metaTablesSQL = "select table_name,table_type from cat where table_type in ('TABLE','VIEW') and table_name not like 'BIN\$%'"

Definition at line 66 of file adodb-oci8.inc.php.

Referenced by MetaTables().

◆ $NLS_DATE_FORMAT

ADODB_oci8::$NLS_DATE_FORMAT = 'YYYY-MM-DD'

Definition at line 97 of file adodb-oci8.inc.php.

◆ $noNullStrings

ADODB_oci8::$noNullStrings = false

Definition at line 87 of file adodb-oci8.inc.php.

◆ $random

ADODB_oci8::$random = "abs(mod(DBMS_RANDOM.RANDOM,10000001)/10000000)"

Definition at line 86 of file adodb-oci8.inc.php.

◆ $replaceQuote

ADODB_oci8::$replaceQuote = "''"

Definition at line 58 of file adodb-oci8.inc.php.

◆ $selectOffsetAlg1

ADODB_oci8::$selectOffsetAlg1 = 1000

Definition at line 96 of file adodb-oci8.inc.php.

◆ $session_sharing_force_blob

ADODB_oci8::$session_sharing_force_blob = false

Definition at line 94 of file adodb-oci8.inc.php.

◆ $sysDate

ADODB_oci8::$sysDate = "TRUNC(SYSDATE)"

Definition at line 60 of file adodb-oci8.inc.php.

◆ $sysTimeStamp

ADODB_oci8::$sysTimeStamp = 'SYSDATE'

Definition at line 61 of file adodb-oci8.inc.php.

Referenced by SQLDate().

◆ $useDBDateFormatForTextInput

ADODB_oci8::$useDBDateFormatForTextInput =false

Definition at line 99 of file adodb-oci8.inc.php.

Public Member Functions

Public Attributes

Detailed Description

Member Function Documentation

◆ _affectedrows()

◆ _close()

◆ _connect()

◆ _nconnect()

◆ _pconnect()

◆ _query()

◆ ADODB_oci8()

◆ BeginTrans()

◆ Bind()

◆ BindDate()

◆ BindTimeStamp()

◆ CharMax()

◆ CommitTrans()

◆ DBDate()

◆ DBTimeStamp()

◆ ErrorMsg()

◆ ErrorNo()

◆ Execute()

◆ ExecuteCursor()

◆ GetRandRow()

◆ IfNull()

◆ IsConnectionError()

◆ MetaColumns()

◆ MetaForeignKeys()

◆ MetaIndexes()

◆ MetaPrimaryKeys()

◆ MetaTables()

◆ Param()

◆ Parameter()

◆ Prepare()

◆ qstr()

◆ RollbackTrans()

◆ RowLock()

◆ SelectDB()

◆ SelectLimit()

◆ ServerInfo()

◆ SQLDate()

◆ TextMax()

◆ Time()

◆ UpdateBlob()

◆ UpdateBlobFile()

Member Data Documentation

◆ $_bind

◆ $_bindInputArray

◆ $_commit

◆ $_dropSeqSQL

◆ $_genIDSQL

◆ $_genSeqSQL

◆ $_getarray

◆ $_hasOciFetchStatement

◆ $_initdate

◆ $_nestedSQL

◆ $_refLOBs

◆ $_stmt

◆ $concat_operator

◆ $connectSID

◆ $databaseType

◆ $dataProvider

◆ $dateformat

◆ $datetime

◆ $firstrows

◆ $hasAffectedRows

◆ $hasGenID

◆ $leftOuter

◆ $metaColumnsSQL

◆ $metaColumnsSQL2

◆ $metaDatabasesSQL

◆ $metaTablesSQL

◆ $NLS_DATE_FORMAT

◆ $noNullStrings

◆ $random

◆ $replaceQuote

◆ $selectOffsetAlg1

◆ $session_sharing_force_blob

◆ $sysDate

◆ $sysTimeStamp