Re: Are there features on other RDBMS's that it would be good for Oracle to have?

From: Ilmar Kerm <ilmar.kerm_at_gmail.com>
Date: Sat, 26 May 2012 09:14:26 +0300
Message-ID: <CAKnHwtesScdn04Cc2dq0D4M6H6COj54QvxPa49KcrYFcNxHmVA_at_mail.gmail.com>



On Sat, May 26, 2012 at 7:33 AM, Paul Linehan <linehanp_at_tcd.ie> wrote:
> Hi all,
>
>
> I'm interested in finding out whether posters to this list wish there
> were features in Oracle that
> are available on other systems?
>
> I saw a posting by Jonathan Lewis
> (http://jonathanlewis.wordpress.com/2010/02/04/sql-server/)
> who says there are some MS SQL Server features that he'd like to see.
> I asked what they
> were but he never replied to my  post.
>
> For example, Oracle has made a big hooha over getting virtual columns.
> A db that I have regularly
> used (Interbase/Firebird) has had them for decades and there's no
> doubt but that they're handy.
> I still think the Firebird syntax is better - Field Blah IS COMPUTED
> BY (expression)
>
> Anything similar on other systems that you use that you think would be
> of benefit for Oracle?
>
> Any ideas, references, URLS, &c. welcome.

Partial indexes in postgresql:
http://www.postgresql.org/docs/9.0/static/indexes-partial.html

Yes I know that its possible in Oracle using functions, but this also means changing the query and its more like a "trick".

-- 
Ilmar Kerm
--
http://www.freelists.org/webpage/oracle-l
Received on Sat May 26 2012 - 01:14:26 CDT

Original text of this message