PEAR is archived and read-only

This mirror preserves historical PEAR package releases and metadata so existing references remain available.

Home » Database » DB » Bug #752

getSpecialQuery('synonyms'); for oracle user synonyms

Details

Request #752getSpecialQuery('synonyms'); for oracle user synonyms
Submitted2004-02-13 18:10 UTC
Frommscifo at php dot net
Assigneddanielc
StatusClosed
PackageDB
PHP VersionIrrelevant
OSANY
Roadmaps(Not assigned)

Comments

[2004-02-13 18:10 UTC] mscifo at php dot net

Description:
------------
Please add support in the oci8 driver to retrieve user (local) synonyms along with user-owned tables.

Addition to oci8.php / getSpecialQuery()

case 'tables':
$sql = "SELECT table_name FROM user_tables";
break;
+case 'synonyms':
+ $sql = "SELECT synonym_name FROM user_synonyms";
+ break;