Soal Basis Data Oracle Null Functions
Soal Basis Data Oracle Null Functions - Berikut adalah soal latihan basis data oracle mengenai null functions dengan jawaban lengkap.
1. The following statement returns 0 (zero). True or False?
SELECT 121/NULL FROM dual;
- False
2. If quantity is a number datatype, what is the result of this statement?
SELECT NVL(200/quantity, 'zero') FROM inventory;
- The statement fails
3. Which function
1. The following statement returns 0 (zero). True or False?
SELECT 121/NULL FROM dual;
- False
2. If quantity is a number datatype, what is the result of this statement?
SELECT NVL(200/quantity, 'zero') FROM inventory;
- The statement fails
3. Which function
Comments
Post a Comment
-Berkomentarlah yang baik dan rapi.
-Menggunakan link aktif akan dihapus.