Re: Outer join in database link query to Sybase

From: DA Morgan <>
Date: Mon, 04 Feb 2008 15:59:59 -0800
Message-ID: <>

Vince wrote:
> I have a need to query records from a Sybase database running on Linux
> (32-bit) and am using Oracle with generic connectivity (no
> specific heterogeneous service for Sybase on Linux). We have installed
> an ODBC driver on the Oracle server and can query the Sybase database
> without difficulty except for outer joins.
> I have tried using both the Oracle syntax and the ANSI syntax. Both
> return results that are consistent with using an inner join. The ANSI
> query, run directly against the Sybase database returns the correct
> data.
> I was looking into the possibility of using dbms_hs_passthrough, but
> it does not appear to be part of the generic connectivity.
> Is there a better/right way of doing this?
> Thanks,
> Vince

Build a view in Sybase that does what you want.

SELECT * from the view.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Mon Feb 04 2008 - 17:59:59 CST

Original text of this message