email address format sql oracle

Question

I want to insert email address as firstname.last_name@domain.com in my table if i do the following:

insert into employee
    values ('EMP01','Mona','Ali',first_name||'.'||LAST_NAME||'@dentalHouse.com'); 

i get column not allowed here. Help please. Dont complicate the answer though.

is there any way to get around rather than typing name again ?

Thank you

Answer 1

I am guessing that you want update:

update employee
    set emailaddress = first_name || '.' || LAST_NAME || '@dentalHouse.com'
    where empid = 'EMP01';

I am just guessing what the id column is named.