我想用下面的sql语句
SELECT DISTINCT nvl(material_code,'$') AS material_code,nvl(material_desc,'$') AS material_desc,material_type,fit_product_clob,key_flag,material_spec FROM hcsp.cd_material WHERE material_type = '111' AND material_type IS NOT NULL and active_flag = '1'AND using_flag = '1'AND deptment_id NOT IN ('20030923001427','ZF200601110001','20030917000061') ORDER BY material_desc来提取oracle表里的数据，其中fit_product_clob是一个clob类型的字段，我把这个查询语句赋给dataAdapter,然后fill给一个datatable，但是这个sql语句本身就取不出数据来，那位高手帮帮忙？能把查询的结果放到一个datatable中啊？
SELECT DISTINCT nvl(material_code,'$') AS material_code,nvl(material_desc,'$') AS material_desc,material_type,fit_product_clob,key_flag,material_spec FROM hcsp.cd_material WHERE material_type = '111' AND material_type IS NOT NULL and active_flag = '1'AND using_flag = '1'AND deptment_id NOT IN ('20030923001427','ZF200601110001','20030917000061') ORDER BY material_desc来提取oracle表里的数据，其中fit_product_clob是一个clob类型的字段，我把这个查询语句赋给dataAdapter,然后fill给一个datatable，但是这个sql语句本身就取不出数据来，那位高手帮帮忙？能把查询的结果放到一个datatable中啊？
但是如果是其他的前端開發語言就需要用另外的相關函數來特殊處理才可以！