Skip to Main Content

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.

Make a range of months between a period

Petri BRAug 23 2010 — edited Aug 24 2010
I want to make a select that gives me a range of months between a period.

I have some initial date and some final date, I want to make a select that returns all the possible months between these dates.


Like that:
Initial date: 01/08/2009
Final date: 16/06/2010

The select would return:

MONTH | YEAR
-----------------------
08 | 2009
09 | 2009
10 | 2009
11 | 2009
12 | 2009
01 | 2010
02 | 2010
03 | 2010
04 | 2010
05 | 2010
06 | 2010

Remembering, I just have two dates, so for a single register I will get a list of months.
Can anyone help me with that please?

Thank you all.

Comments

2709705

Similarly, in the Russian version Windows 8.1.

After join to the domain, jre7u55, jre7u60, jre8, jre8u5 not installed.

There is a temporary solution:

1. Install English Lang Pack

2. Apply English for Display language and Copy settings to Welcome screen and system accounts

http://nexus.orel.ru/1.png

3. Return the old language, and copy settings to New user accounts

4. jre7u55, jre7u60, jre8, jre8u5  install successfully.

2709705

This problem not fixed in jre7u65/8u11.

2727771

We also have this problem on many machines. Have you found any solution without editing language? Java 7 Update 67 did not fix the problem. We have Norwegian language.

Bjørn Erik

2727771

That is good. I can't understand why this bug get priority 3. It should have been priority 1 if you ask me. We have over 8000 computers where java install fails, so we have to run on Java 7 Update 51 unntil this is resolved. Is there anyone in Oracle who can say anything aboute the fixtime for this issue? It is critical.

Regards
Bjørn Erik

2743728

We have the same issue with German Windows 8.1. Changing the language is not an option. This bug is reported since July 14 and still no fix. Trying to update to Java Runtime Environment 8.0 build 20 (64-bit) is failing too. Oracle may should start fixing there bugs instead of joining with ASK. => Oracle is now the ASK Company.......

2727771

So now this bug is closed as incomplete because they could not reproduce it. I have a way to reproduce it. If you have all that is known here, Norwegian/Russian/German or any other localized Windows 8/8.1 and joined to a domain. Then download Java 7 Update 55 or newer version, exe or msi, and then disconnect network before installing. Then you will get this error every time. I really hope someone in Oracle can see this and give the consultant working with this BUG this information. For us this BUG is very critical.

Bjørn Erik

shruda

Hi,

I have the same problem on two German windows 8.1 machines! I'm able to install the JDK but not the contained or separate JRE -> tested with JRE 7u67 & JRE8u20.

The suggest workaround (user: 2709705) -> install the english language pack.

Maybe a interessting information -> I saw the "Restore Java security promts" dialog the first time after the english language pack installation & the default display language switch.

Restore Java security prompts.png

Regards,

Steve

PS: I had a problem to install the english language pack on my Windows 8.1 machine -> the language pack wasn't available .... the answer of this form thread fixed my problem: Language Pack not usable message in Windows 8.1

Hello Folks!

I do have the same problem here. Actually installed is Java JRE 1.7 (7.0.600.19), and I wanted to upgrade to version 7u65 or 8u20, but without success.

Here I use Windows 8.1 Pro, German version, and the notebook is also part of a domain network, but not always connected to it.

Both options to try to install the Java update are failing: connected to the domain network or not connected... :-(

Error message reports, that Java-Update has not been finished. Errorcode: 1603.

When I read the messages, I recognize, that there are several users, who are having the same problems to update Java. I would be thankful to Oracle for some support...

2014-10-10_17-21-58_Fehlermeldung_Java_Update.jpg

user6439156

whats going on with this fu..ing Oracle, 4 months without a reaktion about this installer bug. the language setting workaround is for enterprise definitifly not aceptable. Oracle it is time to do something!

2727771

The bug is finally fixed. Can anyone in Oracle say anything about when you will release a version with this fix included? I hope you can rerelease Update 67 with this fix included.

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

Post Details

Locked on Sep 21 2010
Added on Aug 23 2010
13 comments
51,615 views