Re: Opinions wanted: MySQL and Oracle Decision

Oracle Express Edition, with a price tag of $0 for production deployment,
it might be worth investigating. Since it uses the same core engine as
all the other editions, it is compatible in SQL and PL/SQL. It just does
not include the internal JVM. This does not impact any Java apps that
only want JDBC access to the database.

In my personal research, I've noticed that small organizations will
usually stay under the 4GB data limit imposed by Express Edition, and
larger organizations are generally willing to pay for the appropriate
edition for their needs (Standard One, Standard, Enterprise) if the app
grows that much. The idea of simply swapping the engine to handle larger
organizations, and having guaranteed 100% compatibility appeals to me.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***
.

Relevant Pages

  • Re: UPDATE problem - FROM Clause not supported in Oracle
    ... >>You mean Oracle can't support Standard SQL92? ... > SQL server code will run unaltered on Oracle. ... code I posted is compliant with entry level SQL-92. ...
    (comp.databases.oracle.server)
  • Re: How to decode in SQL Server 2005
    ... non-standard, non-portable features such as the join syntax, DECODE, ... NVL even though Oracle has long since supported the ... ISO standard alternatives. ... The main reason is that we use what we know best. ...
    (comp.databases.ms-sqlserver)
  • Re: How to decode in SQL Server 2005
    ... Yet I still see Oracle developers today using the legacy non-standard, non-portable features such as the join syntax, DECODE, NVL even though Oracle has long since supported the ISO standard alternatives. ... Oracle implemented SQL92 features much later than IBM, Microsoft or Sybase so I suppose that's one reason why the standard seems less widely adopted on Oracle. ... Net change in functionality 0 ...
    (comp.databases.ms-sqlserver)
  • Re: Hints in Practice
    ... and do not conform to any standard. ... Thus you don't use array processing, don't use exception handling, don't use PL/SQL packages, and heaven-forbid don't use any type of index other ... then embrace Oracle. ... If they are confident about the optimizer, why are hints necessary? ...
    (comp.databases.oracle.server)
  • Re: 2G limitation
    ... and has been installed 32-bit Versions of Windows Server 2003 standard ... Oracle can only recognize 2G memory when I have ... You may not be able to use all the available memory on the box.http://support.microsoft.com/kb/291988 ... Windows Server 2003, Standard Edition only in a production environment ...
    (comp.databases.oracle.server)