歌词里一直都记得是什么歌？

if-else, case or decode inside of a ref cursor

I have this big code where I want 3 things in my search: 1- look for all the orders (delivered and not) that match the search: