PLSQL_dummies/minMax.sql at master · FrancescoDiSalesGithub/PLSQL_dummies · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110

declare

somma_tot integer;
output_number integer;

procedure somma(x in integer,y in integer)
is
begin

	somma_tot:=x+y;
	dbms_output.put_line(somma_tot);


end;

procedure max_number(x in integer,y in integer)
is
begin

 if(x>y)then

 	dbms_output.put_line(x);
 	dbms_output.put_line('maggiore di');
 	dbms_output.put_line(y);

 else

	dbms_output.put_line(x);
 	dbms_output.put_line('maggiore di');
 	dbms_output.put_line(y);

 end if;

end;

procedure min_number(x in integer,y in integer)
is
begin

	if(x<y)then

		dbms_output.put_line(x);
		dbms_output.put_line('minore di');
		dbms_output.put_line(y);

	else

		dbms_output.put_line(y);
		dbms_output.put_line('minore di');
		dbms_output.put_line(x);


	end if;

end;

procedure min_max_equal_number(x in integer,y in integer,output out integer)
is
begin


	if(x<y)then

		dbms_output.put_line(x);
		dbms_output.put_line('minore di ');
		dbms_output.put_line(y);
		output:=-1;
	elsif(x>y) then

		dbms_output.put_line(x);
		dbms_output.put_line('maggiore di ');
		dbms_output.put_line(y);
		output:=0;

	else

		dbms_output.put_line(x);
		dbms_output.put_line('uguale a ');
		dbms_output.put_line(y);
		output:=1;
	end if;


end;


begin

	somma(2,2);
	max_number(3,2);
	min_number(3,2);
	min_max_equal_number(3,2,output_number);

	case output_number

		when -1 then
			dbms_output.put_line('minore');
		when 0 then
			dbms_output.put_line('maggiore');
		when 1 then
			dbms_output.put_line('uguale');

	end case;


end;