diff options
| author | Mark Newnham <mark@newnhams.com> | 2026-02-19 19:21:30 -0700 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2026-02-19 19:21:30 -0700 |
| commit | 8ac6fa21f4dab9a3b8435674411b8fac4457259d (patch) | |
| tree | 5877a9d05e629313fc40f19aada51979b6f86837 | |
| parent | 90909bb0de4d0c62952ad10d7fcb331c183c5a2c (diff) | |
| parent | 7ab6bd64f56ff977d51a8b3368586d9bf5e9fd72 (diff) | |
| download | adodb-8ac6fa21f4dab9a3b8435674411b8fac4457259d.tar.gz adodb-8ac6fa21f4dab9a3b8435674411b8fac4457259d.tar.bz2 adodb-8ac6fa21f4dab9a3b8435674411b8fac4457259d.zip | |
Merge pull request #1196 from ADOdb:1195-oci8-metadatabases-does-not-return-list-of-databases-in-lower-case
Return list of databases in lowecase and update exclusion list
| -rw-r--r-- | drivers/adodb-oci8.inc.php | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/drivers/adodb-oci8.inc.php b/drivers/adodb-oci8.inc.php index f08700fd..683039ae 100644 --- a/drivers/adodb-oci8.inc.php +++ b/drivers/adodb-oci8.inc.php @@ -65,7 +65,15 @@ class ADODB_oci8 extends ADOConnection { var $concat_operator='||'; var $sysDate = "TRUNC(SYSDATE)"; var $sysTimeStamp = 'SYSDATE'; // requires oracle 9 or later, otherwise use SYSDATE - var $metaDatabasesSQL = "SELECT USERNAME FROM ALL_USERS WHERE USERNAME NOT IN ('SYS','SYSTEM','DBSNMP','OUTLN') ORDER BY 1"; + var $metaDatabasesSQL = " +SELECT LOWER(USERNAME) FROM ALL_USERS + WHERE USERNAME NOT IN ('SYS','SYSTEM','OUTLN','DBSNMP', +'APPQOSSYS','AUDSYS','CTXSYS','DVSYS','GSMADMIN_INTERNAL', +'LBACSYS','MDSYS','OJVMSYS','ORDDATA','ORDPLUGINS','ORDSYS', +'SI_INFORMTN_SCHEMA','WMSYS','XDB','XS\$NULL','BAASSYS' +,'DBSFWUSER','DGPDB_INT','DIP','DVF','GGSHAREDCAP','GGSYS','GSMCATUSER' +,'GSMUSER','MDDATA','OLAPSYS','PDBADMIN','REMOTE_SCHEDULER_AGENT','SYS\$UMF','SYSBACKUP' +,'SYSDG','SYSKM','SYSRAC','VECSYS') ORDER BY 1"; var $_stmt; var $_commit = OCI_COMMIT_ON_SUCCESS; var $_initdate = true; // init date to YYYY-MM-DD |