Re: JavaDB / Apache Derby equivalent to the SQL Server IsNull, Oracle nvl and MySQL IfNull


James Appleby wrote on 10.08.2007 17:48:
I'm trying to add support for Apache Derby to a piece of software that
already has support for Oracle, SQL Server and MySQL. There is a lot
of DB specific coding involved to get the best performance possible.
Several of these queries involve checking to see if a nested query
returns a value and substituting 0 if no rows are returned.

In Oracle the function is called: nvl
In SQL Server the function is called: IsNull
In MySQL the function is called: IfNull

I can't find an equivalent for Derby. Does one exist?

CASE or NULLIF

http://db.apache.org/derby/docs/10.2/ref/rrefcasenullif.html

Thomas
.

Relevant Pages

  • Re: JavaDB / Apache Derby equivalent to the SQL Server IsNull, Oracle nvl and MySQL IfNull
    ... already has support for Oracle, ... of DB specific coding involved to get the best performance possible. ... In SQL Server the function is called: ... In MySQL the function is called: ...
    (comp.lang.java.databases)
  • RE: Windows Services and SQL Server
    ... There are managed providers for Oracle, MySQL and other RDBMS's. ... SqlClient class with a regular SQL Server login? ... I'm using ODBC Drivers ...
    (microsoft.public.dotnet.languages.csharp)
  • Parameterized queries to different data providers
    ... I would like to build my app so it can connect to SQL Server, Oracle ... or mySQL and query data. ... Data queries should be parameterized to reduce impact of SQL ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle - MySQL decision
    ... I'm suprised you've not considered Microsoft SQL Server 2005 Express edition ... I'd choose Oracle since I have used it since version 7 and I ... > MySQL 5.0 on the other hand is a close contender. ... Many potential customers have flexible site ...
    (comp.databases)
  • Re: Iseries/AS400 access to external databases
    ... You can read/write data from any RPG program to SQL Server, Oracle, MySQL or ... external clients via ODBC, service programs, etc. ... guess Oracle and MySQL might be other sources but not in our case). ...
    (comp.sys.ibm.as400.misc)