Retrieve records from another database
Please help me for retrieving data from a table in a database to the same table located in another database, not on the same server, different users and passwords.
I need suggests about the SQL Statement, or if somebody can help me how to do this using Toad, it will be O.K.
Thanks in advance,
select * from RemoteUser.RemoteTableName@RemoteDatabaseLink
ask your DBA to create a remote database link.
refer the syntax for creating remote database link.
Click Here to Expand Forum to Full Width