Re: Set schema="yourdb"

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 - 21:13:59 CDT