Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Miscellaneous > Filling up the ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 6833 of 6998
Post > Topic >>

Filling up the results of a query

by Hans Mayr <mayr1972@[EMAIL PROTECTED] > Apr 14, 2008 at 09:41 AM

Hello,

I could not find an answer for my following problem through Google,
maybe because I did not find the best keywords. So I hope that one of
you can help me.

I need to create a view that "fills up" the entries of a table.
Example: Let's consider a table t_rates with bank rates for borrowing
money for a certain duration:

Duration_Months; Rate
3; 4.0%
6; 4.5%
12; 4.8%

The problem is that I need a value for all durations, not only the
ones I have. So I would like to create a view that calculates (e.g.
interpolates, extrapolates) the rates. Result:

Duration_Months; Rate
1; 4.0%
2; 4.0%
3; 4.0%
4; 4.2%
5; 4.4%
6; 4.5%
....

Whatever the rates will be, that is not im****tant for me right now.
What I need is the sequence of all durations.

I could solve this through normal sql if I created an auxiliary table
t_numbers with a single column containing all the integer numbers I
needed and doing an outer join from t_numbers on t_rates. But I do not
like the idea of having such a dumb table t_numbers.

What is the best approach for my problem? Some form of "select from
dual"? Or PL / SQL?

Thanks.

Hans
 




 8 Posts in Topic:
Filling up the results of a query
Hans Mayr <mayr1972@[E  2008-04-14 09:41:49 
Re: Filling up the results of a query
Ed Prochak <edprochak@  2008-04-14 11:29:02 
Re: Filling up the results of a query
yf110@[EMAIL PROTECTED]   2008-04-14 16:04:02 
Re: Filling up the results of a query
Ed Prochak <edprochak@  2008-04-15 05:21:46 
Re: Filling up the results of a query
Hans Mayr <mayr1972@[E  2008-04-16 07:26:50 
Re: Filling up the results of a query
Peter Nilsson <airia@[  2008-04-21 20:48:35 
Re: Filling up the results of a query
Hans Mayr <mayr1972@[E  2008-06-03 02:26:49 
Re: Filling up the results of a query
Ed Prochak <edprochak@  2008-06-03 07:25:29 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Wed Jul 9 1:06:08 CDT 2008.