I did some reseach and apparently there are difference between different 12c releases.
In the one used in Live SQL the error is not raised (it is using 12.2.*) but the error is raised using prior release. (12.1.*)
(for this you need to specify the column name, if you use * it will not raised the Oracle Error)
But strange is why do we have mention of this serror still in 12.2 doc ? Any one having a hint else to whom should i raise this question (ask tom?)