Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle if else statement

Re: oracle if else statement

From: yossarian <yossarian99_at_operamail.com>
Date: Wed, 06 Jun 2007 12:40:13 +0200
Message-ID: <46668f0c$0$21206$5fc30a8@news.tiscali.it>


odelya wrote:

> select *from table
> if value!= null then
> where value = table.value
> end if
>
> value = will be a string which might be null.

IIUC, assuming that "value" is a bind variable:

select * from table where table.value=:value or :value is null ; Received on Wed Jun 06 2007 - 05:40:13 CDT

Original text of this message

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