Oracle 新手學習筆記之二

一、測試

declare l_card_id number;
        v_result  varchar2(1000);
begin
   select t.card_id into l_card_id from (
          select t.rowid from sup_card t
          where t.card_id = 41
          order by t.card_No desc,t.up_load_date asc
          ) R
    inner Join sup_card t on R.Rowid = t.rowid
          where rownum < 2;
   
    if (l_card_id is null) then
       v_result := 'It is null';
    elsif (l_card_id = 0) then
       v_result := 'Zero';
    else
       v_result := l_card_id;
    end if;
   
    dbms_output.put_line(v_result);
end;

問題：1. 如果查詢card_id的資料沒有，那麼t.card_id into l_card_id時，將拋出異常

2. elseif 的寫法是 elsif，少了個e.