Mega Code Archive
Assigning values to variables
SQL>
SQL> declare
2 v_length NUMBER DEFAULT 5;
3 v_height NUMBER := 4;
4 v_width NUMBER;
5 v_volume NUMBER;
6 v_min NUMBER;
7 begin
8 v_width := 3;
9 v_volume:= v_length*v_width*v_height;
10 v_min := least(v_length,v_width,v_height);
11 end;
12 /
PL/SQL procedure successfully completed.
SQL>