- 1

Oracle Length with concat operator

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

6th Feb 2019, 7:09 AM
Ajith Kumar
Ajith Kumar - avatar
1 ответ
0
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! 😎
5th Feb 2022, 7:21 AM
Giacomo Montali