Why will I tell you that case is an extended version of DECODE. In this section, you can easily understand the basic difference between CASE and DECODE. Difference Between CASE and DECODE in Oracle The below comparison will help you out which is good for use. So I have also explained the difference between Case and Decode in Oracle. Now most the people ask me then what will we use for Decode or Case. The problem is that flag is not in an aggregation function. Decoding from base64 Hi,I'm in need to encode and decode big xml, however when i'm decoding from base64 after some iterations it fails to decode and i get symbols like this, 'S FS S FS S '. Without a group by, only one group is in the result set, summarizing all the data. We are taking same example for the simple understanding. This is the query producing the error: SELECT DECODE (FLAG, 1, SUM (Qty2), SUM (Qty1)) FROM testv WHERE itemno 1234567 This is an aggregation query. We can say it is an extended version of Decode. It is same as decode for perform IF-THEN-ELSE logic.Ĭase was introduced in Oracle 8.1. It is also perform transfer your data to the another data. The Decode function compares one expression to one or more other expressions and, when the search term is found, returns the match result. Question 1:- What is Case in Oracle?Ĭase is a statement in Oracle. It is automatically converted to the data type of the first search value before comparing.

The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement. The following example is slightly different from the one above. Oracle / PLSQL: DECODE Function Description. Now let's take some questions with answer on the Case Statement in Oracle. The Oracle DECODE() function allows you to add the procedural if-then-else logic to the query. May be, Now above questions with answer will help you out for the better understanding about the Decode Function. 10 is search value and Oracle is result.Let's understand in details if dept_no is 10 then decode function return Oracle, If dept_no is 20 then decode function return java same as for all and last is default if 10,20,30,40 dept_no is not found then decode function return TI support. In the above example dept_no is expression. ) Question 3:- Example of Decode Function in Oracle If the first result is NULL, then the return value is converted. Question 2:- Syntax of the Decode FunctionĭECODE (expression, search, result. The DECODE function returns a value that is the same datatype as the first result in the list. Decode helps to perform IF-THEN-ELSE logic in the SQL query. Question 1:- What is Decode in Oracle?ĭecode is a function in Oracle which helps to transfer your data to the another data. In this blog post, we will understand some basic difference between Case and Decode in Oracle with the help of some questions and answer. In this SQL Tutorial, We will explore about the Difference between Case and Decode in Oracle.

Decode oracle plsql