Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: More Newbie questions...
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