Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sybase and inline views, Intersect, MINUS

Re: Sybase and inline views, Intersect, MINUS

From: Carl Kayser <kayser_c_at_bls.gov>
Date: Thu, 19 Oct 2006 10:38:22 -0400
Message-ID: <eh82ku$bdb$1@blsnews.bls.gov>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US