Single problem

From: Epicentre Team A ANNECY <djeanneret_at_epicentre.fr>
Date: Wed, 5 Jun 2002 10:02:41 +0200
Message-ID: <adkgfq$rvt$1@wanadoo.fr>

We have one schema (environment schema) for many others. Problem is that we must have one environment by instance !.

Example

Actually the only way is
SELECT * from My_env_schem.T1

Is possible to have ...

Variable_Schema_name := 'My_env_schem1'; SELECT * into RecordStruct From Variable_Schema_name.T1 Variable_Schema_name := 'My_env_schem2'; SELECT * into RecordStruct From Variable_Schema_name.T1

Bests regards
Epicentre Team A, Denis Received on Wed Jun 05 2002 - 03:02:41 CDT