Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How I get Schema-Name from sql query

Re: How I get Schema-Name from sql query

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 5 Jan 2000 15:14:33 GMT
Message-ID: <84vn4p$es0$1@news.seed.net.tw>

<pook4431_at_my-deja.com> wrote in message news:84qslv$kuq$1_at_nnrp1.deja.com...
> How I get schema name for schema that I'm using by sql query?
>

This method can also be used in a procedure/function/package to identify the schame name.

SQL> select username from all_users where user_id=userenv('schemaid');

USERNAME



SCOTT Received on Wed Jan 05 2000 - 09:14:33 CST

Original text of this message

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