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 revision		Previous 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:03] – 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:reference: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