sql - invalid identifier -
i trying run query reason keep giving me below error
ora-00904: "distance_in_metres": invalid identifier
can please sort issue, appreciated or guidance on this.
you can not use column defined in select clause in same select clause. logically select clause evaluated @ once. simplified example:
select 1 test, 2 * test dual ora-00904: "test": invalid identifier
as kashi points out in comment, distance_in_metres
referenced in case expression following definition of distance_in_metres
in same select clause, , error coming from.
Comments
Post a Comment