D darkblood Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-27 #1 我想在运行过程中创建一个临时表，应该怎么创建？ 把另一个表的结构复制到这个临时表，怎么操作？
L lynu Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-27 #2 sqlserver的话可以用 select into #temptable
W withdraw Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-27 #3 create table XXX as select ..... from ... sql server & sybase create table #table 就是临时表 oracle 只能 创建一个session 或是commit 的临时表 create global temporary table( ) on commit preserve rows;/on commit delete rows;
create table XXX as select ..... from ... sql server & sybase create table #table 就是临时表 oracle 只能 创建一个session 或是commit 的临时表 create global temporary table( ) on commit preserve rows;/on commit delete rows;
