Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JavaDB / Apache Derby equivalent to the SQL Server IsNull and Oracle nvl

843859Aug 10 2007 — edited Aug 12 2007

Firstly, if questions for JavaDB are supposted to go somewhere else, sorry for posting in the JDBC section, but I couldn't find a specific section for it.

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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 9 2007

Added on Aug 10 2007

#java-database-connectivity-jdbc

1 comment

933 views