Oracle 存储过程:这样一个存储过程还可以优化多少?
存储过程 PR_HELP
/* Formatted on 2014/9/12 16:12:44 (QP5 v5.227.12220.39754) */
CREATE OR REPLACE PROCEDURE DEMO.PR_HELP_CONTENT (
vID IN TB_HELP.ID%TYPE,
vTITLE IN TB_HELP.TITLE%TYPE,
vKEYWORD IN TB_HELP.KEYWORD%TYPE,
vHELPID IN TB_HELP.HELPID%TYPE,
vCONTENT IN TB_HELP.CONTENT%TYPE,
vADDUSERID IN TB_HELP.ADDUSERID%TYPE,
vHOT IN TB_HELP.HOT%TYPE,
vGameId IN TB_HELP.GAMEID%TYPE,
vSortId IN TB_HELP.SORTID%TYPE,
oResInt OUT INT,
oResStr OUT VARCHAR2)
IS
/******************************************************************************
NAME: PR_HELP_CONTENT
PURPOSE:
REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2014/7/28 myTEST 1. Created this procedure.
NOTES:
Automatically available Auto Replace Keywords:
Object Name: PR_HELP_CONTENT
Sysdate: 2014/7/28
Date and Time: 2014/7/28, 18:29:39, and 2014/7/28 18:29:39
Username: myTEST (set in TOAD Options, Procedure Editor)
Table Name: (set in the "New PL/SQL Object" dialog)
******************************************************************************/
i INT;
newId INT;
currReplyTime DATE;
newReplyTime DATE;
BEGIN
SELECT COUNT (1)
INTO i
FROM TB_HELP
WHERE ID = vID;
IF i = 0 THEN
SELECT NVL (MAX (ID), 0) + 1 INTO newId FROM TB_HELP;
INSERT INTO TB_HELP (ID,
HELPID,
KEYWORD,
TITLE,
CONTENT,
ADDUSERID,
HOT,
GAMEID,
SortId,