Thanks the or syntax will work fine. It is just several years since I wrote the templates. I actually sat on the ANSI database committee when they first approved the SQL standard :-)
On 09/25/2013 02:38 PM, Tim Callaghan wrote: > 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 <g...@blu.org > <mailto:g...@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 <g...@blu.org <mailto:g...@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@blu.org <mailto:Discuss@blu.org> > http://lists.blu.org/mailman/listinfo/discuss > > -- Jerry Feldman <g...@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@blu.org http://lists.blu.org/mailman/listinfo/discuss
