Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kalyana chakravarthy maddipati
You can make a remote connection in a database using DBLINK(Database link). it is a named object in the database.
To create a DBLINK this is the syntax
Create dblink XX(DBLInk Name) connect to USERNAME identified by PASSWORD using DATABASENAME.
To access data from remote place using DBLink this is the way
select * from table_name@xx(DBLink name).
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is an inner join?
How to connect of datebase with sql express.?
What is rs.exe utility?
Can you explain full-text query in sql server?
How to Check if table exists in sql server?
What are the triggers in sql?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
Explain how you can configure a running aggregate in SSRS?
What are the steps you can take to avoid “deadlocks”?
What are the differences between lost updates and uncommitted dependencies?
In case you have filters in your report, when filters will be applied in cached report instance?
Do I need a report server to run reports in my application?
What is join and name different type of joins?
If user is owning any SQL Objects, can we drop that user
is it important for a database administrator to understand the operating system and file access? : Sql server administration
