Is there any control structure statement similar to select case ... ? If yes how to use it. I have tried to use, case when <expression> then <expression> end, but not worked well as I want to use other control structures and sql statements to be executed for each case.
Please reply.
Thanks
CPK.
