Re: [SQL] accessing multiple database

2005-05-05 Thread Richard Huxton
mohammad izwan ibrahim wrote: Hi Richard Huxton, Tq for your advice, Hope you can help me on this 1.can I create view from dblink query I believe so - see the dblink docs for details. 2.can I fetch the data simultaneous from multiple database using dblink function, how the syntax would be? Not in

Re: [SQL] accessing multiple database

2005-05-05 Thread mohammad izwan ibrahim
d izwan ibrahim" <[EMAIL PROTECTED]> Date: Thursday 5 May 2005 15:06:24 Subject: Re: [SQL] accessing multiple database > mohammad izwan ibrahim wrote: > > hi all, > > > > im finding some ideas, method, advice, n etc on accessing multiple > > database.The

Re: [SQL] accessing multiple database

2005-05-05 Thread Richard Huxton
mohammad izwan ibrahim wrote: hi all, im finding some ideas, method, advice, n etc on accessing multiple database.The system that i'm currently develop is real time update and the data reside on few different db at different db site. Tq in advance. Obviously you can access more than one database fr