1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
| declare cursor sidy is
select txnlpatterna as MOBILE, billed_duration as duree, callbnumber as destination from conso_post
where callbnumber ='APPEL INTERCEL GSM' or
callbnumber ='APPEL SOTELGUI GSM' or
callbnumber ='APPEL ORANGE' or
callbnumber ='APPEL AREEBA' or
callbnumber ='APPEL CELLCOM' or
callbnumber ='APPEL INTERNATIONAL';
phone number;
calltime number;
destiny varchar2(25);
begin
open sidy;
loop
fetch sidy into phone, calltime, destiny;
------------------------------------------------------------
je veux placer ici la requete d'insertion dans la table
qui se trouve dans un autre schema
-----------------------------------------------------------------
end loop;
close sidy;
end; |
