Question
What is the maximum number of partitions you ever had in a partitioned table?
Less than 100
Between 100 and 500
Between 500 and 1000
Between 1000 and 2000
More than 2000
I never used partitioning
No idea or not applicable
Answer and see the results
Download PLATO
The free tool for auditing and tuning your database
Version 52 now available
Jul 12, 2010
The DBA-Village forum
Forum as RSS
as RSS feed
DBA Top 10
1 M. Cadot 146300
2 F. Pachot 130200
3 B. Vroman 77200
4 A. Kavsek 62650
5 P. Wisse 52900
6 T. Boles 52350
7 Z. Hudec 41600
8 A. Chavan 25700
9 A. Deledda 23200
10 V. Swamy 17625
About
DBA-Village
Site Statistics
Ever registered41903
Total active users26384
Act. users last 24h318
Act. users last hour13
Hits last week5251
Hits last month21266
Go up

Convert Rows into Columns
Next thread: Enteprise Manager
Prev thread: Rman Restore issue

Message Score Author Date
Hi I Have data like this in a table <pre> 1...... swathi sharma Feb 09, 2010
a test case, create table and insert statements ...... Michel Cadot Feb 09, 2010
Search Pivot on this forum http://www.dba-villa...... dattatraya walgude Feb 09, 2010

Follow up by mail Click here

Subject: Convert Rows into Columns
Author: swathi sharma, India
Date: Feb 09, 2010, 211 days ago
Os info: Linux
Oracle info: Oracle 10G
Message: Hi

I Have data like this in a table 


1501-2001  2001-3000 3001-4000 4001-5000

1             2         3        3

0            25        45       60

0            50       135      180 







Now i want this in the below way



Range       Emps    Rate of Tax   Total

1501-2001    1        0             0

2001-3000    2       25            50     

3001-4000    3       45           135 

4001-5000    3       60           180


Solution would be appreciated

Thanks in advance

Swati
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Convert Rows into Columns
Author: Michel Cadot, France
Date: Feb 09, 2010, 211 days ago
Message:
a test case, create table and insert statements for your example to work with should be appreciated.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Convert Rows into Columns
Author: dattatraya walgude, India
Date: Feb 09, 2010, 211 days ago
Message: Search Pivot on this forum

http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=17682

Regards
Dattatraya
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here