Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: More Newbie questions...

Re: More Newbie questions...

From: Eric Kimble <ekimble_at_wfl.fha.dot.gov>
Date: Thu, 15 Aug 2002 13:09:29 -0700
Message-ID: <3D5C0A79.C095BD92@wfl.fha.dot.gov>


Look up synonyms. Used to create a reference to a particular object. Just a hint.
Eric

abc_at_iom.com wrote:

> 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:09:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US