note 124145 added to function.oci-server-version
| From: | Anonymous@php.net | Date: | Tue, 27 Aug 2019 12:25:49 +0000 |
| Subject: | note 124145 added to function.oci-server-version | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-212024@lists.php.net to get a copy of this message | ||
Here's now to extract just the major.minor version number:
<?php
$link = oci_new_connect($username, $password, $server, "AL32UTF8");
$server_info = oci_server_version($link);
$version = preg_replace('~^.* (\d+\.\d+)\.\d+\.\d+\.\d+.*~s', '\1',
$server_info);
echo "$server_info<br>";
// Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
echo "$version<br>";
// 11.2
?>
And here's how to look up version via SQL:
https://www.oracle.com/pls/topic/lookup?ctx=db122&id=ADMIN11039
SELECT * FROM PRODUCT_COMPONENT_VERSION;
PRODUCT VERSION STATUS
---------------------------------------- ----------- -----------
NLSRTL 12.1.0.0.1 Production
Oracle Database 12c Enterprise Edition 12.1.0.0.1 Production
PL/SQL 12.1.0.0.1 Production
?>
----
Server IP: 208.43.231.9
Probable Submitter: 185.85.3.168 (proxied: 195.178.95.132)
----
Manual Page -- http://php.net/manual/en/function.oci-server-version.php
Edit -- https://master.php.net/note/edit/124145
Del: integrated -- https://master.php.net/note/delete/124145/integrated
Del: useless -- https://master.php.net/note/delete/124145/useless
Del: bad code -- https://master.php.net/note/delete/124145/bad+code
Del: spam -- https://master.php.net/note/delete/124145/spam
Del: non-english -- https://master.php.net/note/delete/124145/non-english
Del: in docs -- https://master.php.net/note/delete/124145/in+docs
Del: other reasons-- https://master.php.net/note/delete/124145
Reject -- https://master.php.net/note/reject/124145
Search -- https://master.php.net/manage/user-notes.php