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
Can a table be moved to different filegroup?
Explain having clause and where clause?
What is a select query statement in ms sql server?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
Explain raiserror in sql server?
Can you edit the .rdl code associated with a linked report?
Mention the different types of replication in sql server.
Can a rule be bound to any column of any data type?
How to make conditional sum in ssrs?
What is always encrypted?
How to create a ddl trigger using "create trigger" statements?
What is the cartesian product of the table?
Can you move the resources after pausing the node? : sql server database administration
Is the primary key column of a table an index in ms sql server?
What are the different sql server versions?
