Re: More Newbie questions...

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 15 Aug 2002 23:00:10 GMT
Message-ID: <3D5C3274.2973A5DE@exesolutions.com>

Joe E O wrote:

> 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.

Provided they have alter session. And assuming they have no use for any object in their current schema.

Might create as many problems as it solves but it certainly is one alternative.

Daniel Morgan Received on Thu Aug 15 2002 - 18:00:10 CDT