Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to group records of different values

user2081225Jul 21 2010 — edited Jul 23 2010
Hi,

I have few records in table in this form:

CDE_FUND_CODE| |CDE_CLM_TYPE| |NUM_PCT| |NUM_SVC_DAYS| |
===========| |==========| |======| |==========| |
3R2A | | I | | 0.7215 | | 1 | |
3R2A | | I | | 0.2785 | | 1 | |
3R2A | | I | | 0.7215 | | 2 | |
3R2A | | I | | 0.2785 | | 2 | |
3R2A | | I | | 1.0000 | | 1 | |
3R2A | | I | | 0.2598 | | 1 | |
3R2A | | I | | 0.2401 | | 1 | |
3R2A | | I | | 0.5001 | | 1 | |

Now the notice the values of NUM_PCT
1) Sum of num_pct of first 2 records is 1.
2) Sum of num_pct of records 3rd and 4th is also 1.
3) num_pct of 5th record is 1.
4) Sum of num_pct of records 6th, 7th and 8th is 1.

So I want to write a query which gives me total 4 rows and output should look like this:-

CDE_FUND_CODE| |CDE_CLM_TYPE| |NUM_PCT| |NUM_SVC_DAYS| |
===========| |==========| |======| |==========| |
3R2A | | I | | 1.0000 | | 1 | |
3R2A | | I | | 1.0000 | | 2 | |
3R2A | | I | | 1.0000 | | 1 | |
3R2A | | I | | 1.0000 | | 1 | |

Please let me know if you have any idea about how to write query to get this output.

Thanks,
Rohit

Comments

Ramon Kroese

Oracle has made some changes as you can read in the Java SE 8u20 release notes (Java™ SE Development Kit 8, Update 20 Release Notes):

Java Installer Changes

A new Microsoft Windows Installer (MSI) Enterprise JRE Installer which enables user to install the JRE across the enterprise, is available. See Downloading the Installer section in JRE Installation for Microsoft Windows for more information. The MSI Enterprise JRE Installer is only available as part of Java SE Advanced or Java SE Suite. For information about these commercial products, see Java SE Advanced and Java SE Suite.

In other words you have to buy Java SE Advanced or Java SE suite to download the MSI Enterprise JRE Installer through My Oracle Support (MOS).

Rogerl-Oracle

The installations are static due to this change starting in 8u20:

http://www.oracle.com/technetwork/java/javase/8u20-relnotes-2257729.html

 

JRE Installation Directory

Starting with JDK 8u20 release, the JRE will be installed in a version specific directory. For example:

C:\Program Files\Java\jre1.8.0_20

The version specific directory naming is intentional and it does not indicate that the JRE install is static.

As with the earlier releases, static JRE install is performed only if STATIC=1 option is passed (via command line or config file) by the user.

-Roger

2812883

You just mentionned they ARE static, yet it says

As with the earlier releases, static JRE install is performed only if STATIC=1 option is passed (via command line or config file) by the user.

If you install 1.8.0_25 and 1.8.0_31 after, you have 2 versions of Java on your machine, because it does not upgrade the previous one (Non static Java installs always upgraded the previous versions). This definately looks like a static install to me, otherwise I should be left with only 1 version of Java. I haven't specified it to be static yet it is behaving like a static install.

1 person found this helpful
2812883

Which also means that poor home users that aren't tech savy at all will eventually be left with a bunch of outdated java 1.8 versions on their machines..

2812883

An answer would be greatly appreciated! Thanks

user3252393

I agree.  We need information from Oracle on this.

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 20 2010
Added on Jul 21 2010
6 comments
1,325 views