Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How I get Schema-Name from sql query
<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