查表

 Create or Replace FUNCTION getEnumValue(etype IN VARCHAR2, val IN VARCHAR2) RETURN 
   VARCHAR2 IS
   descrip varchar2(75); 
 BEGIN
   select description into descrip from TABLE_NAME where enumtype = etype and value = val;
 RETURN descrip;
 END;

然后在我的dataset查询中调用这个特定函数并传入所需的属性。