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 cursor. write example of it. What are the attributes of cursor.

967


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

707


What is difference between my sql and sql?

712


how to include comments in sql statements? : Sql dba

716


What are the types of keys?

668






What are stuff and replace function?

768


Define concurrency control. : Transact sql

785


Is sql a case sensitive language?

703


What is difference between stored function and application function?

757


explain advantages of myisam over innodb? : Sql dba

794


What is a pragma statement?

952


Which one is faster ienumerable or iqueryable?

653


What is the difference between row level and statement level trigger?

714


How does an execution block start and end in pl sql?

670


Is sql considered coding?

756