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 will you get by the cursor attribute sql%notfound?
Explain the order of sql statement execution?
What is pivot in sql?
Does truncate need commit?
what is a composite key ? : Sql dba
Can you skip header records while loading? : aql loader
how to check myisam tables for errors? : Sql dba
What does where 1 1 mean in sql?
What is hibernate and its relation to sql?
IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????
How to select all records from the table?
What does where 1/2 mean 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)