Oracle's use of midstream labels

1)---The use of 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 the cursor

Exit when Stock_cur%notfound;

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

End Loop;

Close stock_cur; --Close cursor

End

This article is from the "Small Li Guangzhi Blog" blog, please be sure to keep this source http://6817977.blog.51cto.com/6807977/1597120

Oracle's use of midstream labels