ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:database:oracle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
v5:database:oracle [2021/04/30 18:18] – [oci805] explain what the driver does dregadv5:database:oracle [2022/02/12 22:02] – mnewnham
Line 87: Line 87:
      
 The default value for ''NLS_DATE_FORMAT'' is ''YYYY-MM-DD''. To include time as well, use ''RRRR-MM-DD HH24:MI:SS'' or set the value to empty to disable this action. The default value for ''NLS_DATE_FORMAT'' is ''YYYY-MM-DD''. To include time as well, use ''RRRR-MM-DD HH24:MI:SS'' or set the value to empty to disable this action.
 +----------------------------------
 ==== Auto-Increment Column ==== ==== Auto-Increment Column ====
 [[v5:dictionary:column_attributes#AUTO or AUTOINCREMENT|Auto-increment]] support for Oracle databases is implemented by creating an on-insert trigger that retrieves a sequence number from a sequence //**SEQ_ + table name **//. This is done by default. [[v5:dictionary:column_attributes#AUTO or AUTOINCREMENT|Auto-increment]] support for Oracle databases is implemented by creating an on-insert trigger that retrieves a sequence number from a sequence //**SEQ_ + table name **//. This is done by default.
 +-----------------------------------
 +==== Session Mode ====
 +From ADOdb **V5.22.1**, You can use external ''(OCI_CRED_EXT)'' or privileged (''OCI_SYSOPER or OCI_SYSDBA'') sessions via the [[v5:connection:setConnectionParameter|setConnectionParameter()]] method, **prior** to establishing a connection.
 +
 +<code php>
 +
 +$db = NewADOConnection('oci8');
 +$db->setConnectionParameter('session_mode',OCI_CRED_EXT);
 +$db->connect(false, 'scott', 'tiger', 'myTNS');
 +
 +</code>
 +
  
 +----------------------------------------------
 ====== oci8po ====== ====== oci8po ======
 <WRAP right box round 300px> <WRAP right box round 300px>
v5/database/oracle.txt · Last modified: 2023/01/25 04:40 by mnewnham