CREATE OR REPLACE PROCEDURE P_TF_F_HOT_CHECK(
title in varchar2
)
IS
BEGIN
SELECT HOT_ID, HOT_TITLE,KEYWORD FROM TF_F_HOT WHERE HOT_TITLE = title;
END;
é£æä¹æå®å¼çæææå¦ï¼ ä¹åææ³çæ¯ è½å¤ä¸æ¥éï¼ ä½æ¯è¿æ ·è¿è¡ï¼ 好å没ä»ä¹ææãã
ææ³å¦ä¹ ä¸ä¸åå¨è¿ç¨ï¼ æ³åä¸ä¸ªï¼ æ§è¡ è¾å
¥çæ¡ä»¶ï¼ æ¥è¯¢åºç»æç åå¨è¿ç¨
æ©ï¼è¿æ ·
åå¦ï¼ä½ é£ä¸ªselect åªè½ æ¥è¯¢å°ä¸æ¡ç»æ
CREATE OR REPLACE PROCEDURE P_TF_F_HOT_CHECK
( title in varchar2)
IS
v_hot_id int;
v_hot_title varchar2(200);
v_keyword varchar2(200);
BEGIN
SELECT HOT_ID,HOT_TITLE,KEYWORD into v_hot_id,v_hot_title,v_keyword FROM TF_F_HOT WHERE HOT_TITLE = title;
dbms_output.put_line(v_hot_id||â,'||v_hot_title||','||v_keyword);
END;
ä¸è¾¹è¿æ¯ä¸ªå建çè¿ç¨
æ§è¡çè¯
begin
P_TF_F_HOT_CHECK('ä½ è¾å
¥é£ä¸ªtitleçå¼');
end;