multiplier.sql

来自「学习PL/SQL时收集的一些经典的SQL源代码」· SQL 代码 · 共 10 行

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;
/