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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Question Using Synonyms

Re: Question Using Synonyms

From: Paul Bennett <bennett_at_cc.gatech.edu>
Date: Mon, 10 Jan 2000 08:05:21 GMT
Message-ID: <38799305.99DEDB51@cc.gatech.edu>


> Connect mary/password_at_mydatabase
> SELECT * from TestJohn;
> Oops : table does not exist...
> ALTER SESSION SET CURRENT_SCHEMA=John;
> SELECT * from TestJohn;
> Hey ; It works...

I use this all the time. Quite handy.

I heard, at least at one point, that this was an unsupported feature.

Received on Mon Jan 10 2000 - 02:05:21 CST

Original text of this message

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