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!

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
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
568 views