Re: how to get a list of schemas on an oracle9i database

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Mon, 27 Sep 2004 19:48:46 GMT
Message-ID: <y8_5d.310$k55.182@newsfe3-gui.ntli.net>

"Alan" <nomorezpam3_at_hotmail.com> wrote in message news:84f54f12.0409271141.5e4710be_at_posting.google.com...
> is there a sql command that will give me a list of schemas in an
> oracle9i database; I've looked through the other postings that ask
> this and I'm just not seeing the results I need (e.g. select username
> from dba_users, etc).
>
> Is there an answer or have I got this all wrong?
>
> Thanks

select username from dba_users DOES give you all the schemas in an oracle database, in oracle to put it simply a user is a schema Received on Mon Sep 27 2004 - 14:48:46 CDT