SQL> create or replace procedure sp_select
2 as
3 begin
4 select OrderId,
5 FirstName,
6 LastName,
7 ProductDescription,
8 state,
9 case when state ='IL'or state ='MD'or state ='CA' then '***' else to_char(Qty) End Qty,
10 case when state ='IL'or state ='MD'or state ='CA' then '***' else to_char(ItemPrice) End
ItemPrice,
11 case when state ='IL'or state ='MD'or state ='CA' then '***' else to_char(ExtendedPrice)
End ExtendedPrice
12 from labfpo;
13 end
14 ;
15 /
SQL> show erro
PROCEDURE SP_SELECT 出现错误:
LINE/COL ERROR
-------- -----------------------------
4/1 PLS-00428: an INTO clause is expected in this SELECT statement
------解决方案--------------------