This question asked in interview and even i don't know its possible or not.
i need query to generate email for employees like
ename starts with 'S' then email@example.com
ename starts with 'A' then Amit@yahoo.com
ename starts with 'C' then firstname.lastname@example.org
ename starts with 'M' then email@example.com
explanation:- if name of employee starts with character 'S' then firstname.lastname@example.org
if name of employee is starts with 'M' then
email@example.com etc like this for ename 'c' firstname.lastname@example.org
depending upon 1st character of ename we to give domain name.
- DB Connect, Native SQL, Query external Oracle??
- Oracle SQL Questions for Oracle Certified Professional Exams IZ007
- Generating Report for Employee's Training Records from PA30
- SQL Query slow with Bind Variables in Oracle 11g
- How to Filter Hierarchical Queries In Oracle
- How to find Top Sql through Queries
- Quota Generation Based on Hiring Dates of Employees
- Auto generation of employee related Certitificates
- Email Notification to approver