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!

How to display sql row in horizontal format based on a value.

SeshuGiriMar 25 2015 — edited Mar 25 2015

I want to display data for user in horizontal form based on a column value. Here is the table structure and insert statements. Also, I have included actual and expected output.

If the pricemethod is 'Guess', I want that value next to price (price_real, price_guess), this will based on code, sellernumber and selldate.

create table TEMP_HORI

(

  CODE         VARCHAR2(30),

  PRICE        NUMBER(20,10),

  SELLDATE     DATE,

  SELLERNUMBER NUMBER(10),

  PRICEMETHOD  VARCHAR2(15)

);

insert into temp_hori (CODE, PRICE, SELLDATE, SELLERNUMBER, PRICEMETHOD)

values ('ABCD', 100.0000000000, to_date('01-10-2014', 'dd-mm-yyyy'), 100, 'Real');

insert into temp_hori (CODE, PRICE, SELLDATE, SELLERNUMBER, PRICEMETHOD)

values ('ABCD', 90.0000000000, to_date('01-10-2014', 'dd-mm-yyyy'), 100, 'Guess');

insert into temp_hori (CODE, PRICE, SELLDATE, SELLERNUMBER, PRICEMETHOD)

values ('ABCD', 101.0000000000, to_date('01-10-2014', 'dd-mm-yyyy'), 299, 'Real');

insert into temp_hori (CODE, PRICE, SELLDATE, SELLERNUMBER, PRICEMETHOD)

values ('ABCD', 109.0000000000, to_date('01-10-2014', 'dd-mm-yyyy'), 500, 'Real');

Actual:

     

CODEPRICESELLDATESELLERNUMBERPRICEMETHOD
ABCD100.000000000010/1/2014100Real
ABCD90.000000000010/1/2014100Guess
ABCD101.000000000010/1/2014299Real
ABCD109.000000000010/1/2014500Real

Expected:

     

CODEPRICE_REALPRICE_GUESSSELLDATESELLERNUMBER
ABCD100.000000000090.000000000010/1/2014100
ABCD101.000000000010/1/2014                                     299
ABCD109.000000000010/1/2014                                     500
This post has been answered by Frank Kulash on Mar 25 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2015
Added on Mar 25 2015
3 comments
2,288 views