On Sat, May 26, 2012 at 7:33 AM, Paul Linehan <linehanp@xxxxxx> 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 -- //www.freelists.org/webpage/oracle-l