临时表问题

Question

本帖最后由 wlalw131415 于 2010-09-15 14:35:52 编辑

Answer 1

没问题啊SQL> create global temporary table TEMP_FACILITY_MITIGATION_INFO
  2  (
  3     RECORDDATE VARCHAR2(10) not null
  4  )on Commit Preserve Rows ;
 
Table created
 
SQL> 
SQL> insert into TEMP_FACILITY_MITIGATION_INFO(RECORDDATE) values('1');
 
1 row inserted
SQL> insert into TEMP_FACILITY_MITIGATION_INFO(RECORDDATE) values('2');
 
1 row inserted
 
SQL> select * from TEMP_FACILITY_MITIGATION_INFO;
 
RECORDDATE
----------
1
2
 
SQL> commit;
 
Commit complete
 
SQL> select * from TEMP_FACILITY_MITIGATION_INFO;
 
RECORDDATE
----------
1
2
 
SQL>

Answer 2

我是用hibernate插的，难道没插进去？我再试试

Answer 3

查询不出数据说明你的session不一样

Answer 4

解决了，我插入数据是用的hibernate，查询是用的ibatis