Hello All,

I have a table with column_name as USERNAME where USERNAME is VARCHAR2(20) and I want to display it as "USERNAME@email.com".
How to write the select query for this.

QUERY:

SELECT USERNAME AS EMAIL FROM STUDENT

Thank you.

select concat(username,'@irma.ac.in') as email from student
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.