Skip to Main Content

APEX

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!

Same sql query with multiple database links

439855Sep 25 2006 — edited Sep 26 2006
Hi All,

i want to execute an sql query for a SELECT LIST Item. which should use database links in it's query.

i'm having a list of database links in the region. say :LOC which is having 10 items each linking to different databases.

i want to use following query for another item in same page.

select customer_name from working_lines@:LOC where
phone_no:phone_no

can i do this.

Thank you All.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2006
Added on Sep 25 2006
5 comments
717 views