List the employee_id and the full name of each employee. Create the full name by combining the first and last names separated by a single space. Show two ways of doing it. 

SELECT employee_id, CONCAT(first_name, ' ', last_name) AS full_name FROM employees;

This is the error I get in oracle while using the CONCAT command. 

Error at line 1/21: ORA-00909: invalid number of arguments 

 

List all the numbers that are even in the table numbers_0_to_9.

SELECT number FROM numbers_0_to_9 WHERE number % 2 = 0;

This is the error I get in oracle. Error at line 1/8: ORA-00936: missing expression

Answer rating: 100% (QA)

You are getting the ORA00909 error because you are not passing any arguments to the CONCAT function ... View the full answer