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 a View ? Can we insert, Update and delete a view?
List the advantages of using stored procedures?
Explain what is lock escalation?
Can two tables share a primary key?
Are semicolons required at the end of sql statements in sql server 2005?
What is built-in function?
How to find Duplicate Records In table?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What are the different types of stored procedures?
How do I create a stored procedure in sql server?
What is delete query?
What are the different types of normalization?
Do you know how to implement service broker?
A trigger can reference objects outside the current database? State true or false.
