Monday 3 November 2014

Declare veriable in oracle procedure.

Hi, today I am talking about variable decleration inside a procedure....




CREATE OF replace PROCEDURE procedure_name 
      p_parameter type[VARCHAR(20)];
AS    
     v_variables number(10);  
BEGIN
  --PROCEDURE BODY
END;


here v_variables is my variable in number datatype. Just look at that he is lies in between AS and BEGIN keywords.

No comments:

Post a Comment