用into赋予多个变量时只需要一个into就可以了,如下
select NEXT_EXPIRY_DATE,CURR_LIMIT,TOTAL_LIMIT into V_NEXT_EXPIRY_DATE,V_CURR_LIMIT,V_TOTAL_LIMIT from p2p.s_fin_prod_interest_info where FINANCE_PROD_ID=i_prod_id;
select NEXT_EXPIRY_DATE,CURR_LIMIT,TOTAL_LIMIT into V_NEXT_EXPIRY_DATE,V_CURR_LIMIT,V_TOTAL_LIMIT from p2p.s_fin_prod_interest_info where FINANCE_PROD_ID=i_prod_id;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29802484/viewspace-1442337/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29802484/viewspace-1442337/