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!

Group by multiple years

jfosteroracleAug 10 2010 — edited Oct 30 2010
I have an application where I need to sum a field by year PLUS the the previous 2 years. When I sum simply by year, it looks like this:

select s.survey_year. sum(ac.plover_calculated_adult) AS totalCalcAdults
from dms.adult_census ac,dms.sites s
where ac.site_id = s.site_id
group by s.survey_year

How do I group by year plus the previous 2 years? I'm at a loss for how to write that.

Thanks in advance!!

JOhn
This post has been answered by Frank Kulash on Aug 10 2010
Jump to Answer

Comments

798692
JRE may not be enabled in your browser. Check whether it is enabled or not?

You can verify that from 'Tools -> Internet Options -> Advanced -> Java (sun)'
1 person found this helpful
User_64CKJ
880537 wrote:
..However, when I view the page in IE8, the applet displays an error message (which I can't seem to decipher).
I'm having trouble deciphering that message as well. ..Mostly because you did not copy/paste it.
1 person found this helpful
883540
my bad...the error looks like this:

java.lang.UnsupportedClassVersionError: HelloWeb : Unsupported major.minor version 51.0
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClassCond(Unknown Source)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source)
at sun.plugin2.applet.Plugin2ClassLoader.loadClass0(Unknown Source)
at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)
at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source)
at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source)
at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Exception: java.lang.UnsupportedClassVersionError: HelloWeb : Unsupported major.minor version 51.0
EJP
The JVM being used by the browser is earlier than the version of javac you compiled the applet with.

So update the browser's JVM or use the -target switch of javac.

If you get a message you can't 'decipher', post it. Just saying you can't decipher it only wastes time.
1 person found this helpful
883540
I'm running Java SE 7, which should be the latest version of Java available. Does this mean I need to update my compiler?

Sorry that I keep asking these questions but I want to make sure my applets will run properly in the future.
Kayaman
Answer
880537 wrote:
I'm running Java SE 7, which should be the latest version of Java available. Does this mean I need to update my compiler?
No, it means that your browser isn't running Java 7, but has an older plugin.
Sorry that I keep asking these questions but I want to make sure my applets will run properly in the future.
Then maybe use the target flag when compiling so it's compatible with 1.5. Version 1.6 tops. Unless you really need to use all the new features.
Marked as Answer by 883540 · Sep 27 2020
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 8 2010
Added on Aug 10 2010
6 comments
1,440 views