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
Post a Comment