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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.