在Oracle8i或以上版本中,可以创建以下两种临时表: 1。会话特有的临时表 CREATE GLOBAL TEMPORARY <TABLE_NAME> ( <column specification> ) ON COMMIT PRESERVE ROWS; 2。事务特有的临时表 CREATE GLOBAL TEMPORARY <TABLE_NAME> ( <column specification> ) ON COMMIT DELETE ROWS; CREATE GLOBAL TEMPORARY TA... Read More
posted @ 2011-12-01 08:56 齐心 Views(448) Comments(0) Diggs(0) Edit