how can create data base link for tow servers (scott
schema) give examples plz
Answers were Sorted based on User's Feedback
Answer / m haribaskar
Create Database Link <<LinkName>>
Connect to <<USerName>>
Idenitfied By <<PAssword>>
Using <<DATABASE_NAME>>
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / gaurav gupta
CREATE PUBLIC DATABASE LINK remote
USING 'remote';
| Is This Answer Correct ? | 0 Yes | 2 No |
What mean sql?
How to fetch alternate records from a table?
How can analyze query after generating explain plan ?
ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.
What is the use of stored procedures?
How do I create a sql script?
How to run pl sql program in mysql?
List the differences between plsql - function & procedures
define data blocks ? : Sql dba
Why commit is not used in triggers?
how many values can the set function of mysql take? : Sql dba
What are tables in sql?
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)