Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Need to form the rows into columns using below data source

User_IT7WJDec 7 2022

@frank-kulash

create table test_lgc(id number, name varchar2(20))
insert all
into test_lgc values (1,'a')
into test_lgc values (1,'b')
into test_lgc values (1,'c')
into test_lgc values (1,'x')
into test_lgc values (1,'y')
into test_lgc values (1,'z')
select * from dual;

select * from test_lgc
image.pngimage.png Now I was able to get the data using above query,, Lead says to remove the hard coding which is highlighted as an blue arrow , those numbers 1 , 2, 3 should be removed, use some logic so that hard coding of sequential numbers can be removed
I am using "Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0"
@frank-kulashIs there any way to remove the hard coding.

Comments

Processing

Post Details

Added on Dec 7 2022
2 comments
129 views