databases Online Quiz - 116
Description: databases Online Quiz - 116 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Attempted
0/20
Correct 0
Score 0
‹
›
Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;
SELECT NULLIF('testing','testing') FROM DUAL ;
SELECT NULLIF(NULL,'testing') FROM DUAL ;
SELECT NVL2('first','second','testing') FROM DUAL ;
select decode('a','b','value-b','d','value-d','a','value-a','NA') result from dual;
Two reasons to create table alias :