Shulou(Shulou.com)06/01 Report--

1)-use cursors with parameters

Declare

CURSOR stock_cur (symbol_in VARCHAR2) IS

SELECT * FROM rate_combine_nr nr WHERE nr.combine_no=symbol_in

Stock_info stock_cur%ROWTYPE

Begin

OPEN stock_cur ('G600000001');-- Open the cursor

Loop

FETCH stock_cur INTO stock_info;-take a value from a cursor

Exit when stock_cur%notfound

Dbms_output.put_line (stock_info.combine_no | |'-'| | stock_info.department_code)

End loop

Close stock_cur;-closes the cursor

End

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.