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
write an SQL query to list the employees who joined in the month of January?
Does sql server 2000 clustering support load balancing?
What is command parameter in ssrs?
Is sql different from sql server?
What are the basic features of a trigger in ms sql server?
Do you know what are the differences between lost updates and uncommitted dependencies?
What is a transactions?
What is the purpose of a table?
What are the parts of a function?
what's the information that can be stored inside a bit column? : Sql server database administration
How to enter unicode character string literals in ms sql server?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is a full text index?
when you create a database how is it stored? : Sql server database administration
Can you explain various data region available in ssrs with their use?