Re: use <schema>

From: Tor Mala <tor.mala_at_netcom-gsm.no>
Date: Mon, 15 Oct 2001 15:54:03 +0200
Message-ID: <9qeppf$6k6$1@lise.netcom.no>

<davide_at_yahoo.com> wrote in message
news:9qenhl$n82a8$1_at_ID-18487.news.dfncis.de...
> Tor Mala <tor.mala_at_netcom-gsm.no> wrote:
> > Need to switch between different schemas and run the same SQL-statements
on
> > them. Prefixing all the tablenames is not an option :(
>
> connect <schemaname>/<password>
>

Which is something completely different than what I asked for, this on the other hand...
ALTER SESSION SET CURRENT_SCHEMA=<SCHEMANAME> is exactly what I was asking for :)

Mala

--

Received on Mon Oct 15 2001 - 08:54:03 CDT