[Discuss] [OT RTFM]Quick Oracle SQL quesiton

[tmcallaghan at gmail.com (Tim Callaghan)]

I assume you now want to get back two rows with one statement, one for
each, right? If so,

select 'schema1' uname, count(*) from dba_users where username like
'%schema1%'
union
select 'schema2' uname, count(*) from dba_users where username like
'%schema2%';


If you just want back a count including both, then,

select count(*) from dba_users where username like '%schema1%' or username
like '%schema2%';





On Wed, Sep 25, 2013 at 1:28 PM, Jerry Feldman <gaf at blu.org> wrote:

> 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
>
>
>
> _______________________________________________
> Discuss mailing list
> Discuss at blu.org
> http://lists.blu.org/mailman/listinfo/discuss
>
>