[Discuss] [OT RTFM]Quick Oracle SQL quesiton

[Jerry Feldman]

I'm modifying some existing SQL templates for use in a internal script
where we are adding a second schema (or user in Oracle) so the new
schemas are schema1 and schema2. I'm just not sure how to change this
query to it can refer to both schemas.

The original line is below is from when we had a single schema.
select count(*) from dba_users where username like '%schema%';


I could simply do it twice because all I do is check the result.
select count(*) from dba_users where username like '%schema1%';
select count(*) from dba_users where username like '%schema2%';







-- 
Jerry Feldman <gaf at blu.org>
Boston Linux and Unix
PGP key id:3BC1EB90 
PGP Key fingerprint: 49E2 C52A FC5A A31F 8D66  C0AF 7CEA 30FC 3BC1 EB90