M
M
marsel812018-10-29 21:18:10
Oracle
marsel81, 2018-10-29 21:18:10

Invalid identifier in the request. How to fix?

There is a table EMPLOYEES(EMPLOYEE_ID,FIRSTNAME,LASTNAME,PATRONYMIC,BIRTHDATE)
You need to make queries and select those who were born in the spring. But ORACLE throws an error ORA-00904 invalid identifier. It's all about the last line with WHERE

SELECT EMPLOYEE_ID,
(LASTNAME  || ' ' || FIRSTNAME || ' ' || PATRONYMIC) AS FULLNAME
FROM EMPLOYEES
WHERE MONTH(BIRTHDATE) BETWEEN 3 AND 5;

Answer the question

In order to leave comments, you need to log in

1 answer(s)
1
1001001, 2018-10-29
@1001001

They would give at least an original error.
I guess that's how it should be doneextract(month from BIRTHDATE)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question