Re: SQL in Pl/SQL

from the rules you just explain, I understand that the following sql should answer the request :

 SELECT ADID INTO V_ADID FROM OP_ADDRESS   WHERE

        (
        CITY = V_CITY  AND  STATE = V_STATE and  
        CITY IS not NULL  AND STATE IS not NULL
        )
       or
        (
        CITY IS  NULL  AND  STATE IS  NULL
        )

In article <3547872F.3C3E590F_at_rspa.dot.gov>, Mark Aengenheyster <"'no spam loser' aengenhm"@rspa.dot.gov> wrote:
>hello everybody!
>
>I am having a serious lapse of intelligence here.
>
>here is my SQL which is inside my PL/SQL function:
> SELECT ADID INTO V_ADID FROM OP_ADDRESS
> WHERE CITY = V_CITY
> AND STATE = V_STATE;
>
>The problem is, city or state could be NULL but not necessarily.
>How do I right the SQL so that it will return a row if the value is NULL
>and if it is not NULL ( = 'something')?
>
>If it is null then I want to write:
> SELECT ADID INTO V_ADID FROM OP_ADDRESS
> WHERE CITY IS NULL
> AND STATE IS NULL;
>
>DECODE won't work and NVL doesn't help. I don't want to get into using
>dynamic SQL.
>What do I do?
>
>Thanks in advance
>

Nicolas

Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member

The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Thu Apr 30 1998 - 10:24:45 CDT