-
Retrieve records from another database
Hi,
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,
Richard
-
select * from RemoteUser.RemoteTableName@RemoteDatabaseLink
ask your DBA to create a remote database link.
(or)
refer the syntax for creating remote database link.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|