R
raj9999
I want to write a sql where I want to get data from target database and
Source database on using UNION clause. But I dont want to use Oracle's
DBLINK.
Oracle version
---------------------------
select col1, col2 from users
UNION
select col1, col2 from users@sourcedb
I want to write above sql in such a way that I dont have to use
oracle's dblink. Can I do something like follows:
Perl - DBI version
-----------------------------
$target_sql = "select col1, col2 from users <from target db connection
string>
UNION
select col1, col2 from users <from source db connection
string>";
$target_sth = $dbh_ods->prepare( $target_sql );
$target_sth->execute();
Source database on using UNION clause. But I dont want to use Oracle's
DBLINK.
Oracle version
---------------------------
select col1, col2 from users
UNION
select col1, col2 from users@sourcedb
I want to write above sql in such a way that I dont have to use
oracle's dblink. Can I do something like follows:
Perl - DBI version
-----------------------------
$target_sql = "select col1, col2 from users <from target db connection
string>
UNION
select col1, col2 from users <from source db connection
string>";
$target_sth = $dbh_ods->prepare( $target_sql );
$target_sth->execute();