We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
because oracle is case sensitive.the value can be in lower or upper case in city column.
suppose city value is Mumbai,here upper function convert the value to MUMBAI and it exactly match with the value you give in where clause like MUMBAI=MUMBAI.hope it helps!
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 7
You are viewing a single comment's thread. Return to all comments →
because oracle is case sensitive.the value can be in lower or upper case in city column. suppose city value is Mumbai,here upper function convert the value to MUMBAI and it exactly match with the value you give in where clause like MUMBAI=MUMBAI.hope it helps!