Oracle Length with concat operator

Question

Today I've got an error while run below query in 11g.
Guys,Plz give solution

Select First_name|| Last_name as Name ,Length (Name) From Employees;

The error i got was.
ORA-00904: "NAME": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Error at Line: 17 Column: 48

Answer 1

I see that you use capital case name for your columns and this makes me think that you used double quotes while creating the table. You habe two solutions: re-create the table without the " so the columns won't be case sensitive or use the " while selecting the columns. Good look! 😎