I'm looking for an efficient way to convert rows to columns in oracle, and I need to deal with lot of records.

Question

0.00/5 (No votes)

See more:

Date	Code	Date
Testing1	XYZ	2018-05-21
Testing2	XYZ	2018-05-21
Testing3	XYZ	2018-05-22
Testing4	XYZ	2018-05-22
Testing5	XYZ	2018-05-22
Testing6	XYZ	2018-05-23
Testing7	XYZ	2018-05-23
Testing8	XYZ	2018-05-24
Testing9	XYZ	2018-05-24
Testing10	XYZ	2018-05-24
Testing11	XYZ	2018-05-25
Testing12	XYZ	2018-05-25
Testing13	XYZ	2018-05-26
Testing14	XYZ	2018-05-26
Testing15	XYZ	2018-05-27
Testing16	XYZ	2018-05-27
Testing17	XYZ	2018-05-27

i need the data like below

2018-05-21	2018-05-22	2018-05-23	2018-05-24	2018-05-25	2018-05-26	2018-05-27
Testing1	Testing3	Testing6	Testing8	Testing11	Testing13	Testing15
Testing2	Testing4	Testing7	Testing9	Testing12	Testing14	Testing16
	Testing5		Testing10			Testing17

What I have tried:

how to achieve this i have tried PIVOT but the columns headers(Date) are not fixed, need to display the 7 date's data from user selected date
please help me thank u

Posted 10-Apr-19 10:40am

Parazival

Updated 1-May-19 6:35am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2019-05-01T06:36:00

Solution 1

I would still use PIVOT but because you don't know the column headers until run-time you need to program some "dynamic SQL" - See Coding Dynamic SQL Statements[^]

Posted 1-May-19 6:36am

CHill60