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!

Split Single Row into Multiple Rows

AFF-MMCLOct 30 2019 — edited Oct 30 2019

Hello,

I have a requirement Where I want to Convert data in first table into second table. How Can I do this using sql/pl/sql. First Table is also Custom and Second table is also Custom.

Emp Code
Emp Name
Desgination
Period1Basic Salary 1Gross Salary 1
House Rent 1Period2Basic Salary 2Gross Salary 2House Rent 2
WS100JohnConsultantJan-191000015000500Feb-191400018000700

MonthYearEmp CodeEmp NameDesignationBasic SalaryGross SalaryHouse Rent
Jan19WS100JohnConsultant1000015000500
Feb19WS100JohnConsultant1400018000700

Thanks and Regards,

Saad Qaiser Khan
Comments
Post Details
Added on Oct 30 2019
#data, #plsql, #sql
3 comments
15,633 views