Sybase and inline views, Intersect, MINUS

From: <dba_222_at_yahoo.com>
Date: 19 Oct 2006 07:16:22 -0700
Message-ID: <1161267381.917651.174870@e3g2000cwe.googlegroups.com>

Dear Experts,

I'm an Oracle guy, and I'm being given an assignment in Sybase.

I have to do lots of comparisons between two Sybase "databases" and note the differences.

Sybase does have:
outer joins, UNION, IN, EXISTS, GROUP BY.

But it seems that my some of my favorite tools in Oracle are not found in Sybase:

inline views, Intersect, MINUS.

Am I correct on this? Or is there a way to do the same behavior in Sybase?

When I did comparisons the other year in Teradata, the only way to ultimately do the tough comparisons was to export everything to file, import it into Oracle, and then do the comparisons. I'm hoping to avoid this with Sybase.

Thanks Received on Thu Oct 19 2006 - 09:16:22 CDT