This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes Alternate SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Alternate SQL" Watch "Alternate SQL" New topic

Alternate SQL

Hasan Pasha

Joined: Feb 23, 2005
Posts: 25
I have a SQL query that would work in Oracle... but if I change the DB then it would not work as I am using Oracle specific fn. (NVL).

I do not have much of an experience with writing SQL queries.
Some one please help me rewrite a generic query that would work on all DB.

My oracle specific query is given below.


Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 29287

To write that in a non-Oracle specific way, you need a subquery that returns the fields that you are adding. Then you can sum up the ones that aren't null. For example (on a smaller query),

Start with a bare bones query like that and then gradually add the rest of your query on.

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Alternate SQL
Similar Threads
Query to test your Oracle skills.
SQL query
Handling Null Values In Jdbc
Regular expression - Pattern and matcher
how to pass array value in sql