Topic: How to generate beautifully request.
Greetings to all.
There is such task:
Procedure on which input the dial-up of parameters moves, should return result of request. Passed-in parameters as a matter of fact it is conditions for where. I.e. it is necessary to generate dynamic request which will use passed-in parameters (parameters or have values or empty) as variables.
Such variants as concatenation and usage case with a heap of variants of request is not desirable. Can eat means oracle implementing such formation of request?