2012年11月28日 星期三
ORACLE 暫存表
---- ON COMMIT DELETE ROWS
---- ON COMMIT PRESERVE ROWS by session
CREATE GLOBAL TEMPORARY TABLE XXX_BY_SESSION
ON COMMIT PRESERVE ROWS
AS SELECT * FROM XXX WHERE ROWNUM <= 0;
select owner, table_name
from all_tables
where temporary = 'Y';
訂閱:
文章 (Atom)