Values statement derives a result from an expression

Examples :

VALUES LOWER(‘ABCD’);

Result : abcd

VALUES (LOWER(‘ABCD’), UPPER(‘abcd’));

Result : abcd ABCD (Since we have used parentheses, results are in the same row)

VALUES LOWER(‘ABCD’), UPPER(‘abcd’);

Result : abcd

ABCD