Oracle store procedure & cursor
CREATE OR REPLACE PROCEDURE TESTING
AS
F_DATE VARCHAR2(10);
CURSOR Hello_Cursor IS
Select A from <your table> where A='ABC';
BEGIN
OPEN Hello_Cursor;
FETCH Hello_Cursor INTO F_DATE;
DBMS_OUTPUT.PUT_LINE(F_DATE);
CLOSE Hello_Cursor;
END;
留言
張貼留言