declare
type t_pole is varray(40) of integer;
pole t_pole;
begin
pole:=t_pole(10,20,30,40,50,60,70,80,90,100,110,120,130,140,150,160,170,180,190,200,210,220,230,240,250,260,270,280,290,300,310,320,330,340,350);
dbms_output.put_line('LIMIT '||' '||pole.limit);
dbms_output.put_line('last '||' '||pole.last);
dbms_output.put_line('count '||' '||pole.count);
dbms_output.put_line('***trim 10 ** ');
pole.trim(11);
dbms_output.put_line('LIMIT '||' '||pole.limit);
dbms_output.put_line('last '||' '||pole.last);
dbms_output.put_line('count '||' '||pole.count);
end;
LIMIT 40
last 35
count 35
***trim 10 **
1 10
2 20
3 30
4 40
5 50
6 60
7 70
8 80
9 90
10 100
11 110
12 120
13 130
14 140
15 150
16 160
17 170
18 180
19 190
20 200
21 210
22 220
23 230
24 240
25 250
26 260
27 270
28 280
29 290
30 300
31 310
32 320
33 330
34 340
35 350
LIMIT 40
last 8
count 24
1 10
2 20
3 30
4 40
5 50
6 60
7 70
8 80
declare
type t_pole is varray(40) of integer;
pole t_pole;
begin
pole:=t_pole(10,20,30,40,50,60,70,80,90,100,110,120,130,140,150,160,170,180,190,200,210,220,230,240,250,260,270,280,290,300,310,320,330,340,350);
dbms_output.put_line('LIMIT '||' '||pole.limit);
dbms_output.put_line('last '||' '||pole.last);
dbms_output.put_line('count '||' '||pole.count);
dbms_output.put_line('***trim 10 ** ');
pole.trim(11);
dbms_output.put_line('LIMIT '||' '||pole.limit);
dbms_output.put_line('last '||' '||pole.last);
dbms_output.put_line('count '||' '||pole.count);
end;
LIMIT 40
last 35
count 35
***trim 10 **
LIMIT 40
last 8
count 24
declare
type t_pole is varray(40) of integer;
pole t_pole;
begin
pole:=t_pole(10,20,30,40,50,60,70,80,90,100,110,120,130,140,150,160,170,180,190,200,210,220,230,240,250,260,270,280,290,300,310,320,330,340,350);
dbms_output.put_line('LIMIT '||' '||pole.limit);
dbms_output.put_line('last '||' '||pole.last);
dbms_output.put_line('count '||' '||pole.count);
dbms_output.put_line('***trim 10 ** ');
pole.trim(11);
dbms_output.put_line('LIMIT '||' '||pole.limit);
dbms_output.put_line('last '||' '||pole.last);
dbms_output.put_line('count '||' '||pole.count);
end;
LIMIT 40
last 35
count 35
***trim 10 **
LIMIT 40
last 8
count 24
declare
type t_pole is varray(40) of integer;
pole t_pole;
begin
pole:=t_pole(10,20,30,40,50,60,70,80,90,100,110,120,130,140,150,160,170,180,190,200,210,220,230,240,250,260,270,280,290,300,310,320,330,340,350);
dbms_output.put_line('LIMIT '||' '||pole.limit);
dbms_output.put_line('last '||' '||pole.last);
dbms_output.put_line('count '||' '||pole.count);
dbms_output.put_line('***trim 10 ** ');
pole.trim(11);
dbms_output.put_line('LIMIT '||' '||pole.limit);
dbms_output.put_line('last '||' '||pole.last);
dbms_output.put_line('count '||' '||pole.count);
end;
LIMIT 40
last 35
count 35
***trim 10 **
LIMIT 40
last 8
count 24