how can create data base link for tow servers (scott
schema) give examples plz

Answers were Sorted based on User's Feedback



how can create data base link for tow servers (scott schema) give examples plz..

Answer / m haribaskar

Create Database Link <<LinkName>>
Connect to <<USerName>>
Idenitfied By <<PAssword>>
Using <<DATABASE_NAME>>

Is This Answer Correct ?    9 Yes 0 No

how can create data base link for tow servers (scott schema) give examples plz..

Answer / gaurav gupta

CREATE PUBLIC DATABASE LINK remote
USING 'remote';

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,


What are the set operators in sql?

0 Answers  


Why do we use procedures?

0 Answers  


What are inner outer left and right joins in sql?

0 Answers  


What does the file extension accdb stand for?

0 Answers  






What are the blocks in stored procedure?

6 Answers   Microsoft,


What jobs use sql?

0 Answers  


How can you fetch first 5 characters of the string?

0 Answers  


I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,


How do you take the union of two tables in sql?

0 Answers  


How does rowid help in running a query faster?

0 Answers  


What are the advantages of indexing?

0 Answers  


Categories