在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(466)
Comments(0)
Diggs(0)

浙公网安备 33010602011771号