SQL & PL/SQL

Hi, iam having two tables

TITLE , 

id_title                    Code_Uom           Area                                         
050540HSD003206S3             M               2424.33
050540HSD003206S2             KM              3434.33
050540HSD00320623             H               3438.44
050540HSD00320654             MP              488.88
050540HSD00320656             KP              3434.88

CODE_UOM

Code           Name
M              Meter
KM             Kilometer
H              Hectare
MP             Cubic meters
JK             foot
KP             square feet

i need a function or package to convert area field into acres by checking the Code_Uom accordingly.

ie.,

in TITLE table if Code_Uom column is M then it should check in CODE_UOM table for code column and the name for it.
if it is meter then the meter should be converted into acres. so here 2424.33 meters should be converted into acres
which is nothing but
Answer: 2424.33 m² = 0.599064 acre
3434.33 km² = 848641.424 acre

Edited by: user9093689 on Dec 27, 2010 8:11 PM