Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sybase and inline views, Intersect, MINUS
<dba_222_at_yahoo.com> wrote in message
news:1161267381.917651.174870_at_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.
Yes.
>
> But it seems that my some of my favorite tools in Oracle are
> not found in Sybase:
>
> inline views, Intersect, MINUS.
Negative on "intersect" and "minus". As of ASE 12.5.2 "inline views" are supported as I remember. 12.5.2 is several years old and has been superceded by 12.5.3, 15.0, and 15.0.1.
>
>
>
> 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.
>
I can sympathize with that viewpoint.
> Thanks
>
Received on Thu Oct 19 2006 - 09:38:22 CDT