sql - ORA-01722: invalid number- select, alias -


i can't write complicated select , alias statements because of these errors.

what's wrong select statement hr tables

select  first_name+', '+last_name+' , '+email  name  employees; 

let's try :

select  first_name || ', ' || last_name  'name'  employees; 

yes, mihai mentioned - || concatenation


Comments

Popular posts from this blog

javascript - Wordpress slider, not displayed 100% width -

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

c++ - OpenMP unpredictable overhead -