Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    2

    Question Unanswered: Query over multiple databases

    Is it possible to include tables of different Oracle databases in one SELECT statement? The databases reside on the same server.

  2. #2
    Join Date
    Feb 2004
    Location
    Chennai
    Posts
    53

    Re: Query over multiple databases

    Originally posted by hadmiraal
    Is it possible to include tables of different Oracle databases in one SELECT statement? The databases reside on the same server.

    why not provided u have dblink to the databases
    -Mathan
    For a quick pocket reference of oracle refer http://pocketoracle.blogspot.com/

  3. #3
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89

    Re: Query over multiple databases

    Originally posted by hadmiraal
    Is it possible to include tables of different Oracle databases in one SELECT statement? The databases reside on the same server.
    Yes it is possible.
    Thanks and Regards,

    Praveen Pulikunnu

  4. #4
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    2

    Re: Query over multiple databases

    Ok, thanks. I will use database links.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •