1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| $dbConnexion = OCILogon('user,'pass', '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.99.1.1)(PORT=1521)))
(CONNECT_DATA=(SID=mabase)
(SERVER=DEDICATED))
)');
$dbStmt=OCIParse($dbConnexion,'select sysdate from dual');
OCIExecute($dbStmt,OCI_DEFAULT);
ocifetchstatement($dbStmt,$tabRes,0,-1,OCI_NUM+OCI_RETURN_NULLS+OCI_FETCHSTATEMENT_BY_ROW);
echo'<fieldset><br>ma date avant ', $tabRes[0][0];
$dbStmt=OCIParse($dbConnexion,"alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS'");
OCIExecute($dbStmt,OCI_DEFAULT);
$dbStmt=OCIParse($dbConnexion,'select sysdate from dual');
OCIExecute($dbStmt,OCI_DEFAULT);
ocifetchstatement($dbStmt,$tabRes,0,-1,OCI_NUM+OCI_RETURN_NULLS+OCI_FETCHSTATEMENT_BY_ROW);
echo'<br>ma date après alter ', $tabRes[0][0],'</fieldset>';
$dbStmt=OCIParse($dbConnexion,"SELECT * FROM NLS_SESSION_PARAMETERS");
OCIExecute($dbStmt,OCI_DEFAULT);
ocifetchstatement($dbStmt,$tabRes,0,-1,OCI_NUM+OCI_RETURN_NULLS+OCI_FETCHSTATEMENT_BY_ROW);
foreach($tabRes as $indLigne=>$ligneTab)
{
echo '<br>';
foreach($ligneTab as $indCol=>$col)
{
echo ' ',$tabRes[$indLigne][$indCol] ;
}
} |
Partager