场景:
基础知识查询
动机:
纯粹基础知识积累,便于后续查询.在很多场合,负责人们都在谈论去IOE话题,
所以,难免使用场合会或多或少会减少,于是按照习惯的思路记录一下.
环境:
Oracle Database 11g; PL/SQL Developer
1.不带参数存储过程
CREATE OR REPLACE PROCEDURE PRO_INSERT_INFO IS
BEGIN
INSERT INTO B_LOG_INFO
SELECT SEQ_DEMO_ID.NEXTVAL,
SYSDATE,
SYSDATE,
'1',
'执行成功',
50,
'DUAL'
FROM DUAL;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END PRO_INSERT_INFO;
2.带参存储过程
CREATE OR REPLACE PROCEDURE PRO_INSERT_INFO_ARGS(IN_DATE IN VARCHAR2 := NULL) IS
BEGIN
DECLARE
V_DATE DATE := TRUNC(SYSDATE - 1);
BEGIN
IF (IN_DATE IS NOT NULL) THEN
V_DATE := TO_DATE(IN_DATE, 'YYYYMMDD');
END IF;
INSERT INTO B_LOG_INFO
SELECT SEQ_DEMO_ID.NEXTVAL,
V_DATE,
SYSDATE,
'1',
'执行成功',
50,
'DUAL'
FROM DUAL;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END;
END PRO_INSERT_INFO_ARGS;
3.调试存储过程
4.开始调试
5.运行
6.带参数运行需输入参数
以上,感谢.