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
List out some of the requirements to set up a sql server failover cluster?
Can group by be used without aggregate functions?
Explain about Normalization?
What happens if null values are involved in datetime operations?
How is sql used in sql server?
What is a data collection table?
What are the various editions of sql server 2017 that are available in the market?
Tell me what is normalization? Explain different forms of normalization?
What are triggers? How do you invoke a trigger on demand?
What are the drawbacks of reporting in ssrs?
What is a partition function in sql server?
What is difference statement and preparedstatement?
How retrieve field names from the table in SQL through JAVA code?
How to create and drop temp table in sql server?
What is spid in sql server profiler?
