Write an SQL query to join three character strings your firs

Write an SQL query to join three character strings: your first name, blank space, and your last name. Use a nested CONCAT function and the DUAL table.

Write an SQL query to calculate the number of months until Christmas. Use the MONTHS_BETWEEN function and the DUAL table. Then, round off the answer to an integer. Decide which function - ROUND or TRANC - to be used for rounding off.

Write an SQL query to display a text string \'JANUARY 21, 2013\' as a date using the TO_DATE function and the DUAL table. (Hint: correct format model to use for this string is \'MONTH DD, YYYY\').

Write an SQL query to display a date \'21-JAN-13\' as a text string using the TO_CHAR function and the DUAL table. You may use any format model that is different from the default Oracle date format.

Solution

Write an SQL query to join three character strings: your first name, blank space, and your last name. Use a nested CONCAT function and the DUAL table.

SELECT CONCAT((SELECT CONCAT(\'FirstName\', \' \') FROM DUAL), \'LastName\') FROM NAMES;