Re: Set schema="yourdb"

That is because it is UNdocumented and UNsupported. On purpose. Oracle may not keep it in future releases.

In the meantime, I use it, too.

JRStern wrote:
>
> Thanks!
>
> Unbelievable how hard it seems, to get this kind of basic stuff out of
> the Oracle docs and even relatively experienced users.
>
> Josh
>
> On 16 Apr 1998 02:13:59 GMT, "Saad Ahmad" <saad.ahmad_at_mchugh.com>
> wrote:
> >alter session set current_schema = <your schema>;
> >
> >
> >Primal Systems, Inc. <JRStern_at_primalsys.com> wrote in article
> ><35355676.27425388_at_news1.occa.home.net>...
> >> OK, there's no such command. Or is there? SQLServer has
> >> a "use" command that does the equivalent, ... or am I
> >> thinking of DBase III?
> >>
> >> I guess the approved approach in Oracle is to use roles, right?
> >>
> >> Josh
> >>
> >>
Received on Wed Apr 15 1998 - 22:22:24 CDT