oracle if else statement

Hi!
I would like to write a statement using if/else for example: select *from table
if value!= null then
where value = table.value
end if

value = will be a string which might be null.

im using oracle 9i Received on Wed Jun 06 2007 - 04:43:58 CDT