Re: Set schema="yourdb"

From: JRStern <JRStern_at_gte.net>
Date: Thu, 16 Apr 1998 03:13:10 GMT
Message-ID: <6h3suh$5gn$5@gte2.gte.net>

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:13:10 CDT