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!

Rows to Column

AzamshareefFeb 28 2014 — edited Feb 28 2014

Hi All,

I have problem with query and table description and data as follows

name varchar2(100),

hdate timestamp,

user varchar2(10)

data

name hdate user

xx 01-jan-2014 12:00:54 am 2444

xx 01-jan-2014 14:00:54 am 2444

xx 01-jan-2014 13:00:54 am 2444

xx 01-dec-2013 12:00:54 am 2444

xx 01-jan-2014 16:00:54 am 2444

I want to display data as follows.

name 01-jan-2014 01-dec-2014

xx 12:00:54 am 12:00:54 am

xx 14:00:54 am

xx 13:00:54 am

xx 16:00:54 am

i want to display date as column name and time as rows....

Can anyone help me in this regards......

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2014

Added on Feb 28 2014

#column, #to

6 comments

189 views