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.
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.