Juan Carlos Oropeza Joe Joe 2 2 bronze badges. Add a comment. Active Oldest Votes. Improve this answer. Lukasz Szozda Lukasz Szozda k 18 18 gold badges silver badges bronze badges. You can use nvl function within decode as : select decode nvl StudentStatus,99 , 99,'Y','N' as status from users Demo. ScaisEdge ScaisEdge k 10 10 gold badges 83 83 silver badges 95 95 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. It means that Oracle evaluates each comparison expression e1, e2,..
Oracle does not evaluate all comparison expressions before comparing any of them with the expression e. As a result, Oracle never evaluates a comparison expression if a previous one equals the input expression e. We will use the products table in the sample database for the demonstration.
I want to return a value based on the combinations in two different fields. Answer: Yes, below is an example of a case statement that evaluates two different fields. While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. Please re-enable javascript in your browser settings.
All legitimate Oracle experts publish their Oracle qualifications. Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback.
0コメント