摘要:
--建立临时表:create global temporary table temp on commit preserve rows [as select * from drv where 1=2] --session 级别 对话关闭后消失create global temporary table temp on commit delete rows [as select * from drv where 1=2] --transaction 级别 提交后消失create or replace procedure pro_show(rn in number)asvar_num number(1 阅读全文