Tag: databases

Which three definitions are associated with implicit cursors?

Which character is used to continue a statement in SQL*Plus?

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(null,'second','third') FROM DUAL ;

SELECT NVL2('first','second','testing') FROM DUAL ;

SELECT NVL(null,'testing') FROM DUAL ;

select decode('a','b','value-b','d','value-d','a','value-a','NA') result from dual;