SQL> Declare
2 i Varchar2(20);
3 Begin
4 i:=Case 3
5 When 1 Then 1.1
6 When 2 Then 1.2
7 End;
8 If i Is Null Then
9 dbms_output.put_line('没有匹配到');
10 Else
11 dbms_output.put_line(i);
12 End If;
13 End;
14 /
没有匹配到
PL/SQL procedure successfully completed
SQL>
SQL> Declare
2 i Varchar2(20);
3 Begin
4 Case 3
5 When 1 Then
6 i:=1.1;
7 When 2 Then
8 i:=1.2;
9 End Case;
10 dbms_output.put_line(i);
11 End;
12 /
Declare
i Varchar2(20);
Begin
Case 3
When 1 Then
i:=1.1;
When 2 Then
i:=1.2;
End Case;
dbms_output.put_line(i);
End;
ORA-06592: 执行 CASE 语句时未找到 CASE
ORA-06512: 在 line 4
SQL>
2 i Varchar2(20);
3 Begin
4 i:=Case 3
5 When 1 Then 1.1
6 When 2 Then 1.2
7 End;
8 If i Is Null Then
9 dbms_output.put_line('没有匹配到');
10 Else
11 dbms_output.put_line(i);
12 End If;
13 End;
14 /
没有匹配到
PL/SQL procedure successfully completed
SQL>
SQL> Declare
2 i Varchar2(20);
3 Begin
4 Case 3
5 When 1 Then
6 i:=1.1;
7 When 2 Then
8 i:=1.2;
9 End Case;
10 dbms_output.put_line(i);
11 End;
12 /
Declare
i Varchar2(20);
Begin
Case 3
When 1 Then
i:=1.1;
When 2 Then
i:=1.2;
End Case;
dbms_output.put_line(i);
End;
ORA-06592: 执行 CASE 语句时未找到 CASE
ORA-06512: 在 line 4
SQL>