Re: Set schema="yourdb"

Aaaaarrggghhhh!!

Josh

On Wed, 15 Apr 1998 22:22:24 -0500, "John P. Higgins" <jh33378nospam_at_deere.com> wrote:
>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 Thu Apr 16 1998 - 13:36:01 CDT