Declare
person_id_v Number(10) :=70;
full_name_v Varchar2(240) ;
Begin
Select full_name Into full_name_v
From hr.per_all_people_f Where person_id = person_id_v;
If full_name_v = '吴' Then
dbms_output.PUT_LINE('吴);
Elsif full_name_v ='aa' Then
dbms_output.PUT_LINE('aa');
Else
dbms_output.PUT_LINE('else');
End If;
End;
person_id_v Number(10) :=70;
full_name_v Varchar2(240) ;
Begin
Select full_name Into full_name_v
From hr.per_all_people_f Where person_id = person_id_v;
If full_name_v = '吴' Then
dbms_output.PUT_LINE('吴);
Elsif full_name_v ='aa' Then
dbms_output.PUT_LINE('aa');
Else
dbms_output.PUT_LINE('else');
End If;
End;