大家好,在Oracle的PL/SQL里怎么执行存储过程?
例:
CREATE OR REPLACE PROCEDURE CRMSPL.TEST(strBegin in Date,strEnd in Date)
IS
aa varchar2(50);
BEGIN
SELECT ka_title into aa FROM EB_KNOWLEDGE_ARTICLE where KA_UNUSED2 >= strBegin and KA_UNUSED3 <= strEnd;
END;
还有SELECT的时候为什么INTO到一个临时表里,实在是不明白,请各位高手给我讲解一下,先谢谢了!