hello, I'm trying to make a query work in a pl/sql procedure. I'd like to be able to search films with 4 different things: name, realisator, actor and genre, and to able to search only one or 2 of those things (so some parameters might be null). here is my procedure: http://pastebin.com/m47e5c6c but the problem it that when all parameters aren't specified, I get a huge result list. could you tell me how I could fix this please?
I think it comes from the tables in the FROM statement that are always present, even if there is a null parameter, but I don't know how to remove the unused tables if I don't use them