I know the decode function.
But i am using in a PL,sql query such that there are multiple statements in the script.
(select ... from.. )
(select.. from.. )
select decode (,,,,....)
The script was running fine and perfect.
until i added the queries for decode.
The decode query works perfect when executed separately but within the script, the result are some errors..
rest of line ingored.
Can anyone tell how to have this decode function inside the script in this case.
I absolutely know the syntax of decode and its running perfect when executed separately from the script.