SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select from remote database (dblink)

575197Sep 17 2012 — edited Sep 18 2012

Hi,

I am wondering if I do select * from <table_name>@dblink will fetch all rows from table on remote database?

Will there be any difference if optimizer_mode is FIRST_ROWS or ALL_ROWS?

I am working on Oracle 11gR2.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 16 2012

Added on Sep 17 2012

9 comments

4,450 views