Error in following PL\SQl Statment

[suresh661]

Hi All,

I'm new to Oracle , if facing syntax error in the following statement (ELS IF). i tried it to my extent . i would be a great help if some one corrects me

Thanks in Advance

Code: Select all


Declare
V_Number1 Number;
V_Number2 Number;
V_Result Varchar2(7);


Begin

If V_Number1 Is Null Or V_Number 2 Is Null Then
 V_RESULT:= 'UnKnown';
   
    ELSE If V_Number1 < V_Number2 Then
    V_Result:='Yes';
    Else
    V_Result :='No';
    End If;
   
DBMS_OUTPUT.PUT_LINE(V_Result);

END;


[Tim...]

Hi.

ELSIF, not ELSE IF.

Code: Select all

DECLARE
  v_number1 NUMBER;
  v_number2 NUMBER;
  v_result  VARCHAR2(7);
BEGIN

  IF v_number1 IS NULL OR v_number2 IS NULL THEN
    v_result := 'UnKnown';
     
  ELSIf v_number1 < v_number2 THEN
    v_result := 'Yes';
  ELSE
    v_result := 'No';
  END IF;
   
  DBMS_OUTPUT.PUT_LINE(v_result);

END;
/

Cheers

Tim...

[suresh661]

thank you very much Tim.

[Tim...]