OraFAQ Forum: SQL & PL/SQL » Displaying rows as columns and grouping data

Home » SQL & PL/SQL » SQL & PL/SQL » Displaying rows as columns and grouping data (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Displaying rows as columns and grouping data [message #674795]

Mon, 18 February 2019 02:15

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

Hello,

I have a table with the below structure

Col_date....Col_value
--------....----------
08-Oct-18...A
09-Oct-18...B
09-Oct-18...C

What I want as a SQL output is

08-Oct...09-Oct
------...-------
A........B
.........C

Any idea how can this be achieved.

Thanks,
Vaibhav

Report message to a moderator

Re: Displaying rows as columns and grouping data [message #674797 is a reply to message #674795]

Mon, 18 February 2019 02:31

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Align the columns in result.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Search for PIVOT.

Report message to a moderator

Previous Topic:	XMLType Column Comparison in Select Query
Next Topic:	Executing dynamic sql using forall

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 06 23:27:27 CST 2026