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 are 3 ways to get a count of the number of records in a table?
What are the differences between having and where clause.
What does ss stand for sexually?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is a bit datatype?
what's the difference between a primary key and a unique key? : Sql server database administration
What is a trigger and its types?
How to query multiple tables jointly?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What are entities and relationships?
What are the different types of data sources in ssrs?
Is sql different from sql server?
Can you index views?
What is 2nf example?
What are basics of policy management?
