Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get First_Name and Last_Name as single column from employee table separated by a '_'?

Rajkumar_29Feb 15 2016 — edited Feb 15 2016

Table Name: Employee

Employee_idFirst_nameLast_nameSalaryJoining_dateDepartment
1JohnAbraham100000001-JAN-13 12.00.00 AMBanking
2MichaelClarke80000001-JAN-13 12.00.00 AMInsurance
3RoyThomas70000001-FEB-13 12.00.00 AMBanking
4TomJose60000001-FEB-13 12.00.00 AMInsurance
5JerryPinto65000001-FEB-13 12.00.00 AMInsurance
6PhilipMathew75000001-JAN-13 12.00.00 AMServices
7TestName112365000001-JAN-13 12.00.00 AMServices
8TestName2Lname%60000001-FEB-13 12.00.00 AMInsurance

Table Name : Incentives

Employee_ref_idIncentive_dateIncentive_amount
101-FEB-135000
201-FEB-133000
301-FEB-134000
101-JAN-134500
201-JAN-133500
This post has been answered by BrunoVroman on Feb 15 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2016
Added on Feb 15 2016
4 comments
3,193 views