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
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
When should you use an instead of trigger?
What is the default sql server instance name?
Can an entity have two primary keys?
What is log ldf?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
How to update values in a table with update statements in ms sql server?
What is tcl in sql server?
What are the aggregate and scalar functions?
Explain the cursor lock types?
What happens when converting big values to numeric data types?
Is it possible to have clustered index on separate drive from original table location?
What is difference between materialized view and view?
What is a cache in ssrs?
What is a linked server in sql server?
