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

Answer Posted / gaurav gupta

CREATE PUBLIC DATABASE LINK remote
USING 'remote';

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a native sql query?

488


Can we use update in sql function?

571


What is data types in sql?

529


Is a view faster than a stored procedure?

540


How do I start sql profiler?

550






Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

638


What are all types of user defined functions?

520


Explain polymorphism in pl/sql.

634


What is not equal in sql?

503


Which table is left in join?

511


Why do we use procedures in pl sql?

516


define join and explain different type of joins? : Sql dba

542


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

605


What is coalesce in sql?

553


What is group by in sql?

541