hi, i'd like to write sth like:
create rule MYRULE as on select to MYTABLE do instead
dblink('dbname=ANOTHERDB',querystring);
where querystring would be a special keyword, as new
and old, but containing the full query which the rule
is invoked, so if i do
insert into TOTO select * from MYTABLE where ... ;
it will act as
insert into TOTO dblink('dbname=ANOTHERDB','select *
from MYTABLE where ...') ;
is there any way to do such, i mean to hide the
dblink, so MYTABLE is the real MYTABLE on ANOTHERDB,
but looks like a normal local table...
___________________________________________________________________________
Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les tarifs exceptionnels pour appeler la France et
l'international.
Téléchargez sur http://fr.messenger.yahoo.com