From: Manoj Thomas <nospam_@nospam_.com>
Subject: Re: schemas
Date: 2000/06/23
Message-ID: <B579106F.7BB0%nospam_@nospam_.com>#1/1
Content-Transfer-Encoding: 7bit
References: <8j03ia$ag2$1@phunn2.um.us.sbphrd.com>
Content-Type: text/plain; charset="US-ASCII"
X-Complaints-To: usenet@news.apple.com
X-Trace: news.apple.com 961790703 11345 17.216.17.53 (23 Jun 2000 20:05:03 GMT)
Organization: Apple Computer, Inc.
Mime-Version: 1.0
User-Agent: Microsoft Outlook Express Macintosh Edition - 5.01 (1630)
NNTP-Posting-Date: 23 Jun 2000 20:05:03 GMT
Newsgroups: comp.databases.oracle.server


select username from dba_users;


> From: "Sougato Das" <sougato_das@hotmail.com>
> Organization: SmithKline Beecham Pharmaceuticals Research & Development
> Newsgroups: comp.databases.oracle.server
> Date: Fri, 23 Jun 2000 12:37:58 -0400
> Subject: schemas
> 
> Does anyone know what query would return the names of all the schemas in the
> database instance I'm currently logged into?
> Oracle v.7.3.3.6.0
> 
> thanks,
> Sougato
> 
>