mercredi 25 avril 2018

Oracle, If-else condition in where clause

Please could you advise? Can we use if else condition in where clause of oracle?

I should execute such example:

We should select all files with name "Car". And if there is no 'car', i should select "Motorbike".

in other words, it should work like this: IF(name = 'Car') then smth related to Car else if(name = 'Car' does not exist) then smth related to Motorbike.

Aucun commentaire:

Enregistrer un commentaire