Interested to Buy Any Domain ? << Click Here >> for more details...
How make remote connection in database?
- 1 Answers
- 3753 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Do you know what is normalization of database? What are its benefits?
Do you know how to make remote connection in database?
How to drop existing indexes in ms sql server?
How to drop an existing stored procedure in ms sql server?
How to return the date part only from a sql server datetime datatype?
What are the differences between ms sql server & oracle?
What is the security principal at the database level that represents your session?
How to delete a login name in ms sql server?
Do you know what are the differences between lost updates and uncommitted dependencies?
What is the process of normalising?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What are built in functions?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
