Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle if else statement
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