Re: How I get Schema-Name from sql query

From: RC <rclarence_at_tyc.com>
Date: Tue, 04 Jan 2000 22:30:07 GMT
Message-ID: <s74t3fmphu8172@corp.supernews.com>

pook4431 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.

Try select USER from dual; That will give you the schema that is currently running.

HTH RC

--
Posted via CNET Help.com
http://www.help.com/ Received on Tue Jan 04 2000 - 16:30:07 CST

This message: [ Message body ]
Next message: Tim Lindsey: "PL/SQL Update/Insert, Need Help"
Previous message: Richard Speiss: "New to Oracle"
In reply to: pook4431_at_my-deja.com: "How I get Schema-Name from sql query"
Next in thread: Paul Bennett: "Re: How I get Schema-Name from sql query"
Reply: Paul Bennett: "Re: How I get Schema-Name from sql query"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US