haozi198736的专栏

SQL> --查看数据SQL> select * from crmcard where cardnum = '100000025'; CARDNUM BYTIME CARDTYPE CARRIER STAT LST

1、编写测试过程find2，如下：create or replace procedure find2( piData in int)is vData int;begin select piData+10 into vData from dual;end find2; 2、在PL/SQL中添加调试信息，如下图：

on commit preserve rows：是指事物提交时保存数据，断开session时数据清除（创建临时表时默认选项）on commit delete rows：是指事物提交时删除数据，断开session时数据清除。eg.create global temporary table TTmpTable04 (    FStr01 VARCHAR2(20) ,    FStr

ALTER SYSTEM SET job_queue_processes =25;