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.

Need to filling null values with values before the date is weekend/holidays

792365Nov 3 2010 — edited Nov 4 2010
I have a table with Date column, Type column and Rate column.

The problem is when weekends and holidays, Type column and Rate column are null.

I need to filling every null value with Type and Rate values before the date is weekend or holidays.

Example:

I have:

DATE TYPE RATE
01/07/2010 4510PM 3.71
01/07/2010 CETE28 4.59
01/07/2010 TIIE28 4.95
02/07/2010 4510PM 3.82
02/07/2010 CETE28 4.63
02/07/2010 TIIE28 5.11
*03/07/2010 NULL NULL*
*04/07/2010 NULL NULL*
05/07/2010 4510PM 3.91
05/07/2010 CETE28 4.74
05/07/2010 TIIE28 5.25

Will be:

DATE TYPE RATE
01/07/2010 4510PM 3.71
01/07/2010 CETE28 4.59
01/07/2010 TIIE28 4.95
02/07/2010 4510PM 3.82
02/07/2010 CETE28 4.63
02/07/2010 TIIE28 5.11
*03/07/2010 4510PM 3.82*
*03/07/2010 CETE28 4.63*
*03/07/2010 TIIE28 5.11*
*04/07/2010 4510PM 3.82*
*04/07/2010 CETE28 4.63*
*04/07/2010 TIIE28 5.11*
05/07/2010 4510PM 3.91
05/07/2010 CETE28 4.74
05/07/2010 TIIE28 5.25

What I could do?
This post has been answered by Frank Kulash on Nov 3 2010
Jump to Answer

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

user6439156

It's now a official bug...

http://bugs.java.com/bugdatabase/view_bug.do?bug_id=8050838

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

1 person found this helpful
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 Dec 2 2010
Added on Nov 3 2010
#code, #date, #pl-sql, #plsql, #sql, #sql-developer
3 comments
510 views