Case vs Decode in oracle sql plsql tutorial Lab Session 2

Описание к видео Case vs Decode in oracle sql plsql tutorial Lab Session 2

Case vs Decode in oracle SQL plsql tutorial Lab Session 2.
Case provides data type inconsistency error but decode does not provides data type inconsistency error. Decode is not used in PLSQL block as a function and will display an error message like 'DECODE' may be used inside a SQL statement only. Decode is easy and shorter to read and understand than case. Case datatype must be same in all the conditional check whereas decode data type may be different in the conditional check. Case is directly used in the plsql block whereas decode is indirectly used in the plsql block.
https://drive.google.com/file/d/1iyGA...

Комментарии

Информация по комментариям в разработке