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 to add more data to the testing table in ms sql server?
What are the main sources of data?
What happens if time-only values are provided as date and time literals?
what is the sql equivaent of the dataset relation object ?
How to end a stored procedure properly in ms sql server?
What is coalesce in sql server?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
What structure can you implement for the database to speed up table reads?
Explain the properties of a relational table?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is database architecture? : SQL Server Architecture
What command do we use to rename a database?
How to rebuild master databse?
Explain cross join or cartesian product in sql?
What is Command line parameters in PLSQL.?
