Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: need sql statement for complex address search

Re: need sql statement for complex address search

From: sean nakasone <seannakasone_at_yahoo.com>
Date: Mon, 30 Jul 2007 13:28:25 -1000
Message-ID: <Pine.WNT.4.64.0707301326470.3916@pgsnakason.hawaiianelectric.net>

I ended up using NVL2

select ... where NVL2(MY_PREFIX, MY_PREFIX || '-' || MY_NUMBER, MY_NUMBER) like ... Received on Mon Jul 30 2007 - 18:28:25 CDT

This message: [ Message body ]
Next message: dean: "Re: Connection over 2000 miles"
Previous message: DA Morgan: "Re: Crack Oracle SYSTEM Passwords like a peanut!"
In reply to: sean nakasone: "Re: need sql statement for complex address search"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US