Re: How to get list of schemas

From: Ban Spam <ban-spam_at_operamail.com>
Date: Sat, 18 Jan 2003 19:15:05 GMT
Message-ID: <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 Sat Jan 18 2003 - 20:15:05 CET

This message: [ Message body ]
Next message: Gilles Mercier: "dbms_output in a PL/SQL loop"
Previous message: Ban Spam: "Re: dbms_output in a PL/SQL loop"
Next in thread: dom: "Re: How to get list of schemas"
Reply: dom: "Re: How to get list of schemas"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message