关于oracle中存储过程的。在线等，求大神们解答

Question

select hmv.hy_time_stamp, mm.cu_name , mm.meter_number
from (select hc.hy_name_last as cu_name,hm.hy_meter_number as meter_number
from hy_customer hc,hy_metainfo_customer hmc, hy_meter_point hmp ,hy_metainfo_meter hmm ,hy_meter hm
where hc.hy_storage_id = hmc.hy_meta_id
and hmc.hy_meter_point_id = hmp.hy_storage_id
and hmp.hy_storage_id = hmm.hy_meter_point_id
and hmm.hy_meta_id = hm.hy_storage_id and hm.hy_meter_number = '12144549') mm
,hy_meas_line hml, hy_meas_val hmv,hy_meter_point hmp
,hy_metainfo_meter hmm ,hy_meter hm

where hml.hy_meter_point_id = hmp.hy_storage_id and hmp.hy_storage_id = hmm.hy_meter_point_id
and hmm.hy_meta_id = hm.hy_storage_id
and hml.hy_storage_id = hmv.hy_meas_line_id and hmv.hy_semantic_id = 'volume.main'
and hmv.hy_time_stamp < Add_months(sysdate,-1) order by hmv.hy_time_stamp;

        这是我在数据库中写的一个查询。。用到了子表等等。。想写成存储过程，最后在netbeans中调用这个，获得这三个数据，，怎么整?

Answer 1

建议你新建一个表，通过存储过程把数据插入到这个表中，然后在netbeans把数据从这个表中取出来即可