I found that this works for me when I pass the database link as a variable.
INSERT INTO [EMAIL PROTECTED] SELECT * FROM foo WHERE condition='bar'; > > --- "Chen, Allen" <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I've searched all over and can't seem to find an answer to this... > > I have > > perl code using DBI and DBD::Oracle where I'm trying to selectively > > copy > > rows from one table to another table on a remote database via an > > Oracle > > database link. The SQL is pretty simple and basically looks like > > the > > following: > > > > insert into [EMAIL PROTECTED] > > select * from foo > > where condition='bar'; > >
