Re: More Newbie questions...

From: Joe E O <josephobrienNOSPAN_at_hotmail.com>
Date: Thu, 15 Aug 2002 16:25:38 -0400
Message-ID: <ulo3ku4cdkf0ab@corp.supernews.com>

alter session set current_schema=theuser

Joe E O

<abc_at_iom.com> wrote in message
news:3d5c014f.73509631_at_news.sf.sbcglobal.net...
> Can you use some setting that will cause Oracle to reference a default
> user?
>
> New to oracle here. Question:
>
> I have a number of tables associated with a user that I've created in
> the database (for this example, let's assume the user is called
> "theuser"). To do a simple select statement, I have to type:
>
> SELECT NAME, .ADDRESS,.PHONE from theuser.PHONEBOOK
>
> Is there a way where I don't have to keep typing "theuser" before
> every object I reference? In otherwords, is there a setting that will
> make Oracle assume I mean "theuser" ?
>
> In a simple select statement, it's not a big deal, but more complex
> ones make for lots of redundant typing.
Received on Thu Aug 15 2002 - 15:25:38 CDT