Skip to content
Advertisement

Concatenate and use in where clause oracle plsql

I have to concatenate two fields and use concatenated field in where clause but it gives me invalid identifier. How to solve this query.

This gives me

Advertisement

Answer

You cannot use a column alias at the same level. Just use a subquery (or repeat the expression):

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement