Community Sites
Create your own community website and start earning today !
It's Free !

Forum Resources Mentors Projects Entrance Exams Question Papers Colleges Courses Universities Schools Make Money

Communities Members Bookmarks Polls Fresher Jobs Funny Photos B.Tech Projects New Member FAQ

My Profile

AdSense Revenue

Active Members
Today

Senthil Kumar (315)
Sandy (270)
Srinath (190)

Last 7 Days

bharath (1510)
Girish Patil (1306)
sunil (1182)

more...

Awards & Gifts

Online Exams

Fresher Jobs

Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian cities including Bangalore, Chennai, Hyderabad, Pune or Kochi

Resources

Find educational articles, blogs, discussion threads and other resources.

Colleges

Find details about any college in India or search for courses.

11g New features - SQL - PIVOT Table

Posted Date: 17 Apr 2008 Resource Type: Articles/Knowledge Sharing Category: Computer & Technology

Posted By: Vinothkumar K Member Level: Gold
Rating:

Points: 4

11g New features - SQL - PIVOT Table

PROD QUARTER AMOUNT
Shoes Q1 2000
Shoes Q2 1000
Jeans Q1 1000
Jeans Q3 500
Jeans Q3 100
Jeans Q4 1000

Query:
SELECT * FROM sales
PIVOT
(sum(amount)
FOR quarter in
‘Q1’,’Q2’,’Q3’,’Q4’);

PROD Q1 Q2 Q3 Q4
Shoes 2000 1000 Null Null
Jeans 1000 Null 600 1000

Oracle 11g - PIVOT Table Features:
Rotate rows into columns and vice versa
Create aggregated cross-tabular result set
Use to combine multiple rows to one, enabling inter-row computations without self-join

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: SQL Server->Timestamp datatype
	Previous Resource: Multiple Table Insert in Oracle
	Return to Discussion Resource Index
	Post New Resource
	Category: Computer & Technology

Post resources and earn money!

Related Resources

Watch TV Channels

Watch Asianet TV online

Kairali TV in Internet

Surya TV online

Amritha TV Channel