drozd001 Posted January 31, 2016 Posted January 31, 2016 Hello.I have the following query:select decode($P{model},-1,'ALL',$P{model}) from models...rest of query...group by decode($P{model},-1,'ALL',$P{model}) This query returns me 00979 ORA Error. How can I fix this?
santosh.audi19 Posted February 1, 2016 Posted February 1, 2016 Few of them faced Issues while using Decode.Using Case definitely works, once try using CASE instead of decode.Hope this helps.Thanks.
drozd001 Posted February 1, 2016 Author Posted February 1, 2016 Ill try using CASE instead of DECODE and ill write it is helpful.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now