为什么在临时表中插入，查询结果却没数据？

insert into glo_prov_rep(brd_id , check_date, pro_new_id , inv_prm_amt, inv_qty, mgmt_city_id, biz_city_id)
select max(t.brd_id) , max(t.check_date) , t.pro_new_id, sum(t.inv_prm_amt), sum(t.inv_qty), t2.mgmt_city_id, t2.biz_city_id
from view_inv_day t , t05_org_info t2
where t.brd_id = &v_brdid
and t.org_new_id = t2.org_new_id
and t2.mgmt_city_id in (&v_mgmt_city_id)
and t2.biz_city_id in (&v_biz_city)
and t.check_date = to_char(to_date(&v_startdate,'yyyymmdd')-1,'yyyymmdd')
group by t2.mgmt_city_id, t2.biz_city_id , t.pro_new_id

单独查询select的时候会显示数据，但是加上insert之后，再次查询这张临时表就没有数据了，为什么啊？还有就是我插入之后也提交了，但是任然没有数据，麻烦高手帮帮忙啊

golbal  temprory table 在执行 COMMIT操作之后,数据会清空,创建了临时表之后,请勿执行COMMIT操作,这样你才能像普通表一样使用这张表.