Re: How I get Schema-Name from sql query

From: TurkBear <johng_at_mm.com>
Date: Mon, 03 Jan 2000 19:40:54 GMT
Message-ID: <3870f9a3.17709514@news.news-ituk.to>

The schema name refers to the owner of object(s) ...each user with resource/connect privs has a schema --

so of you select owner,table_name from user_tables the owner will be your login name...

If you
select owner,table_name from all_tables the owners listed will be the all schemas that have tables in the database ( that you have at least select rights on)

Perhaps schema is not what you are trying to discover ?

pook4431_at_my-deja.com wrote:

>How I get schema name for schema that I'm using by sql query?
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Jan 03 2000 - 13:40:54 CST