-
The return data type of Decode and NVL are......
Decode function return data type is always the same as its first returned argument.
select decode(hiredt,’09-SEP-1979’,NULL,hiredt)
In the above case the return data type is VARCHAR2, since NULL has a VARCHAR2 data type. In the above case, we can make sure that the return data type is date, by applying a to_date function on the null value.
select decode(hiredt,’09-SEP-1979’,to_date(NULL),hiredt)
Similarly NVL \'s return datatype is the same datatype as its first returned argument.
Answer : It is the same datatype as its first returned argument.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|