Re: Default schema...

In article <1993Mar18.160524.8588_at_lgc.com>, jason_at_lgc.com (Jason Pritchard) writes:
|> In article 93Mar17222413_at_ap221sun.oracle.com, alaw_at_oracle.com (Alvin W. Law) writes:
|> >jason_at_lgc.com (Jason Pritchard) writes:
|> >
|> >>In other words, I connect as "a" but want to have "b" as the default
|> >>schema.
|> >
|> >I know it doesn't answer your question but the easy workaround is to
|> >create synonyms <object name> as <schema>.<object name>
|> >
|> > Alvin W. Law .............................................. Oracle Corporation
|>
|> Thanks.....but, synonyms are not what I need because of the following:
|>
|>
|> However, if I can change the default quickly, then all I have to do is make
|> sure that the default is set correctly before I issue each query.
|>
|> Any ideas????
|>
|> --Jason
|>
Use variables for the schema name, and set them under each connection.

define default=A

select * from &default.table_a

|> ===================================================================
|>
|> Jason Pritchard
|> Landmark Graphics Corporation
|> Framework Engineering, Database Technology Group
|> Houston, Texas
Received on Thu Mar 18 1993 - 23:29:47 CET