DEAR ALL,

Please help me to make a query

In Table-1 (UTL_CHARGES) we have start_mrl, end_mrl and Value Column Names with Following Data


LINE_ID	START_MRL	END_MRL	VALUE

1	1		5	500
2	5.1		10	600
3	10.1		15	800
4	15.1		20	1000
5	20.1		25	2000
6	25.1		30	3000

In Table-2 (UTL_FINAL) we have Unit_mrl, Ret_val Column Names with Following Data

UNIT_MRL	RET_VAL

7	
11	
16	
26	
3	

Output Result in Table-2 (utl_final) according to following condition

If utl_final.unit_mrl between utl_charges.start_mrl and utl_charges.end_mrl then
utl_final.Ret_val = Utl_charges.value (In case of 7 utl_final.Ret_val = 600 because 7 between 5.1 and 10 in Table-1 (UTL_CHARGES) and so on.


Output will be as follows in Utl_Final table


UNIT_MRL	RET_VAL

7		600
11		800
16		1000
26		3000
3		500


TABLE-1 

INSERT INTO UTL_CHARGES ( LINE_ID, START_MRL, END_MRL, VALUE ) VALUES ( 
1, 1, 5, 500); 
INSERT INTO UTL_CHARGES ( LINE_ID, START_MRL, END_MRL, VALUE ) VALUES ( 
2, 5.1, 10, 600); 
INSERT INTO UTL_CHARGES ( LINE_ID, START_MRL, END_MRL, VALUE ) VALUES ( 
3, 10.1, 15, 800); 
INSERT INTO UTL_CHARGES ( LINE_ID, START_MRL, END_MRL, VALUE ) VALUES ( 
4, 15.1, 20, 1000); 
INSERT INTO UTL_CHARGES ( LINE_ID, START_MRL, END_MRL, VALUE ) VALUES ( 
5, 20.1, 25, 2000); 
INSERT INTO UTL_CHARGES ( LINE_ID, START_MRL, END_MRL, VALUE ) VALUES ( 
6, 25.1, 30, 3000); 
COMMIT;



TABLE-2 (OUTPUT)




INSERT INTO UTL_FINAL ( UNIT_MRL, RET_VAL ) VALUES ( 
7, NULL); 
INSERT INTO UTL_FINAL ( UNIT_MRL, RET_VAL ) VALUES ( 
11, NULL); 
INSERT INTO UTL_FINAL ( UNIT_MRL, RET_VAL ) VALUES ( 
16, NULL); 
INSERT INTO UTL_FINAL ( UNIT_MRL, RET_VAL ) VALUES ( 
26, NULL); 
INSERT INTO UTL_FINAL ( UNIT_MRL, RET_VAL ) VALUES ( 
3, NULL);  
COMMIT;

SCOTT> desc emp
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 EMPNO                            NOT NULL NUMBER(4)
 ENAME                                     VARCHAR2(10 CHAR)
 JOB                                       VARCHAR2(9 CHAR)
 MGR                                       NUMBER(4)
 HIREDATE                                  DATE
 SAL                                       NUMBER(7,2)
 COMM                                      NUMBER(7,2)
 DEPTNO                                    NUMBER(2)

SCOTT> desc salgrade
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 GRADE                            NOT NULL NUMBER
 LOSAL                                     NUMBER
 HISAL                                     NUMBER

SCOTT> select e.ename, e.sal, s.grade
  2  from emp e, salgrade s
  3  where e.sal between s.losal and s.hisal
  4  order by e.ename
  5  /
ENAME             SAL      GRADE
---------- ---------- ----------
ADAMS            1100          1
ALLEN            1600          3
BLAKE            2850          4
CLARK            2450          4
FORD             3000          4
JAMES             950          1
JONES            2975          4
KING             5000          5
MARTIN           1250          2
MILLER           1300          2
SCOTT            3000          4
SMITH             800          1
TURNER           1500          3
WARD             1250          2