oracle存储过程

oracle中的存储过程

--搜索关键字的记录

CREATE OR REPLACE PROCEDURE P_NEWKEYWORD(
	p_keyword VARCHAR
)IS
	v_keyword_id number;
	v_now date:=sysdate;
BEGIN
	BEGIN
		SELECT ID INTO v_keyword_id FROM KEYWORDS WHERE keyword=p_keyword AND ROWNUM=1;
		UPDATE KEYWORDS
		SET COUNTS=COUNTS+1
		WHERE ID=v_keyword_id;
	EXCEPTION
	WHEN NO_DATA_FOUND THEN
		SELECT KEYWORDS_SEQ.NEXTVAL INTO v_keyword_id  FROM DUAL;
		INSERT INTO KEYWORDS
		(ID,keyword,spell,counts,state,created_at,updated_at)
		values
		(v_keyword_id,p_keyword,'','0','0',v_now,v_now);
	END;
	
END P_NEWKEYWORD;