Member Avatar for Azii

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.

Edited by Azii
  • 2 Contributors
  • 1 Reply
  • 184 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by urtrivedi
Member Avatar for urtrivedi 
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.