Re: How to get list of schemas
From: dom <dominic.morris_at_eidosnet.co.uk>
Date: 19 Jan 2003 01:58:40 -0800
Message-ID: <c5c9bfea.0301190158.73c00b7c_at_posting.google.com>
Date: 19 Jan 2003 01:58:40 -0800
Message-ID: <c5c9bfea.0301190158.73c00b7c_at_posting.google.com>
Hi Ban Spam!
Many thanks for this! Works a treat.
I'd like to drill down the DB structure: please see my new thread! Thanks again.
dm.
Ban Spam <ban-spam_at_operamail.com> wrote in message news:<Xns930772BB3F9E1SunnySD_at_68.6.19.6>...
> dominic.morris_at_eidosnet.co.uk (dom) wrote in
> news:c5c9bfea.0301180753.5274a10f_at_posting.google.com:
>
> > Hi all,
> >
> > I would like to know if it is possible to query an Oracle system table
> > to return a list of the Schema names in a given Oracle database. I'm
> > using Oracle 9i.
> >
> > Many thanks,
> > dm.
> >
>
> SELECT USERNAME FROM DBA_USERS;
Received on Sun Jan 19 2003 - 10:58:40 CET