Skip to content

PIVOTING in Oracle (via Abhishek Gupta)

January 12, 2011

PIVOTING in Oracle TOC Pivoting in Oracle 10g / earlier versions Pivoting in Oracle 11g Pivoting in Oracle 10g / earlier versions Pivoting is used for changing rows into columns in a SQL Query (Crosstab). Suppose we have a table TEST_PIVOT with some data as below:               And suppose we want to know number of SE, SSE, TL, PM in each team then we can get this by specifying the query: select  DESIGNATION, max(decode(TEAM, 'A', … Read More

via Abhishek Gupta

From → Others

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: