还是create GLOBAL TEMPORARY table 的问题!谢谢!
EMP表中有3条数据,在SP中,先执行
create GLOBAL TEMPORARY table AA ON COMMIT PRESERVE ROWS as (select * from emp)
select count(*) into v_count from AA
v_count的值为3
再执行根据AA建立BB
create GLOBAL TEMPORARY table BB ON COMMIT PRESERVE ROWS as (select * from AA)
select count(*) into v_count from BB
v_count的值为0
为什么?
如何让BB也有数据?
谢谢!