j'ai crée une vue basé sur plusieur table mais avec une requete et union comme suit :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
CREATE OR REPLACE VIEW V_DAILY_OPEN AS
SELECT risk ,soci,sum(dpl_posit.mtm_pl) as cash,0 as future,0 as options,0 as inventorie,0 as freit,0 as forex
from dpl_posit
group by risk,soci
UNION
select risk,soci,0 as cash,sum(dpl_futures.mkt_price)as future,0 as options,0 as inventorie,0 as freit,0 as forex
from dpl_futures
group by risk,soci
union
select risk,soci,0 as cash,0 as future,sum(dpl_options.mkt_prime) as options,0 as inventorie,0 as freit,0 as forex
from dpl_options
group by risk,soci
union
select risk,soci ,0 as cash,0 as future,0 as options,sum(dpl_stock.mkt_price)as inventorie,0 as freit,0 as forex
from dpl_stock
group by risk,soci
union
select risk,soci,0 as cash,0 as future,0 as options,0 as inventorie,sum(dpl_fret.mkt_price) as freit,0 as forex
from dpl_fret
group by risk,soci
union
select risk,soci ,0 as cash,0 as future,0 as options,0 as inventorie,0 as freit,sum(dpl_forex.mkt_price)as forex
from dpl_forex
group by risk,soci

elle affiche des des resultats en pl/sql develloper
mais quand je linsere dans un block en designer et j'execute une query , j'ai le message erreur suivant :
FRM 40505 oracle erreur :unable to preform query

merci.