multiplier.sql

学习PL/SQL时收集的一些经典的SQL源代码

Create or replace procedure multiplier
	(v_num1	in 	number,
	 v_num2		in	number)
Is
	 v_result		number;
Begin
	 v_result := v_num1*v_num2;
	 dbms_output.put_line('The multiplier value is: '||to_char(v_result)) ;
End multiplier;
/