How to convert rows returned by a query into columns in oracle?

Posted by Piyush Lohana on Stack Overflow See other posts from Stack Overflow or by Piyush Lohana
Published on 2011-01-01T17:49:29Z Indexed on 2011/01/01 17:54 UTC
Read the original article Hit count: 351

Filed under:

convert

|

column

|

pivot

|

rows

I have to display the results of the below query as columns.

select to_char(sysdate + 1 - rownum,'MON-YYYY') as d from all_objects where trunc(sysdate + 1 - rownum,'MM') >= trunc(to_date(:from_date,'MON-YYYY'),'MM') minus select to_char(sysdate + 1 - rownum,'MON-YYYY') as d from all_objects where trunc(sysdate + 1 - rownum,'MM') > trunc(to_date(':to_date','MON-YYYY'),'MM')

Please help me in figuring that out.

© Stack Overflow or respective owner

Related posts about convert

Monitoring SQL Server Agent job run times

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Introduction A few months back, I was asked how long a particular nightly process took to run. It was a super question and the one thing that struck me was that there were a plethora of factors affecting the processing time. This said, I developed a query to ascertain process run times, the… >>> More
Convert Dynamic to Type and convert Type to Dynamic

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
public static class DynamicExtensions { public static T FromDynamic<T>(this IDictionary<string, object> dictionary) { var bindings = new List<MemberBinding>(); foreach (var sourceProperty in typeof(T).GetProperties().Where(x => x… >>> More
Need help in filtering the data with various condition and filling in scroll window GP

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I am filtering the data and displaying in scroll window. There are many combination to display this data by customer id, customer id and itemnumber, customer id, itemnumber, work and history condition. And from date and To date condition. My query is when I am selecting the customer id and… >>> More
Convert and convert back datetime in Django

as seen on Stack Overflow - Search for 'Stack Overflow'
I am parsing feeds using feedparser and I am trying to store updated or updated_parsed attributes of feeds in Django db. But it shows an error as [u'Enter a valid date/time in YYYY-MM-DD HH:MM[:ss[.uuuuuu]] format.'] Please tell me how to convert updated and updated_parsed such that it can be stored… >>> More
Redaction in AutoVue

as seen on Oracle Blogs - Search for 'Oracle Blogs'
As the trend to digitize all paper assets continues, so does the push to digitize all the processes around these assets. One such process is redaction - removing sensitive or classified information from documents. While for some this may conjure up thoughts of old CIA documents filled with nothing… >>> More

Related posts about column

Metro: Introduction to CSS 3 Grid Layout

as seen on Stephen Walter - Search for 'Stephen Walter'
The purpose of this blog post is to provide you with a quick introduction to the new W3C CSS 3 Grid Layout standard. You can use CSS Grid Layout in Metro style applications written with JavaScript to lay out the content of an HTML page. CSS Grid Layout provides you with all of the benefits of using… >>> More
Metro: Introduction to CSS 3 Grid Layout

as seen on Stephen Walter - Search for 'Stephen Walter'
The purpose of this blog post is to provide you with a quick introduction to the new W3C CSS 3 Grid Layout standard. You can use CSS Grid Layout in Metro style applications written with JavaScript to lay out the content of an HTML page. CSS Grid Layout provides you with all of the benefits of using… >>> More
php foreach question

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following code $oldID=-1; $column=0; foreach($pv->rawData as $data){ if ($oldID!= $data->relativeTypeID){ $oldID= $data->relativeTypeID; $column++; $row=1; } echo "Row: ".$row.": Column: ".$column.": ID".$data->relativeTypeID."<br>";… >>> More
Test Column exists, Add Column, and Update Column

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to write a SQL Server database update script. I want to test for the existence of a column in a table, then if it doesn't exist add the column with a default value, and finally update that column based on the current value of a different column in the same table. I want this script to be… >>> More
Update table.column with another table.column with common joined column

as seen on Stack Overflow - Search for 'Stack Overflow'
Hit a speed bump, trying to update some column values in my table from another table. This is what is supposed to happen when everything works Correct all the city, state entries in tblWADonations by creating an update statement that moves the zip city from the joined city/state zip field… >>> More