1-- 2-- PORTALS_P2 3-- 4BEGIN; 5DECLARE foo13 CURSOR FOR 6 SELECT * FROM onek WHERE unique1 = 50; 7DECLARE foo14 CURSOR FOR 8 SELECT * FROM onek WHERE unique1 = 51; 9DECLARE foo15 CURSOR FOR 10 SELECT * FROM onek WHERE unique1 = 52; 11DECLARE foo16 CURSOR FOR 12 SELECT * FROM onek WHERE unique1 = 53; 13DECLARE foo17 CURSOR FOR 14 SELECT * FROM onek WHERE unique1 = 54; 15DECLARE foo18 CURSOR FOR 16 SELECT * FROM onek WHERE unique1 = 55; 17DECLARE foo19 CURSOR FOR 18 SELECT * FROM onek WHERE unique1 = 56; 19DECLARE foo20 CURSOR FOR 20 SELECT * FROM onek WHERE unique1 = 57; 21DECLARE foo21 CURSOR FOR 22 SELECT * FROM onek WHERE unique1 = 58; 23DECLARE foo22 CURSOR FOR 24 SELECT * FROM onek WHERE unique1 = 59; 25DECLARE foo23 CURSOR FOR 26 SELECT * FROM onek WHERE unique1 = 60; 27DECLARE foo24 CURSOR FOR 28 SELECT * FROM onek2 WHERE unique1 = 50; 29DECLARE foo25 CURSOR FOR 30 SELECT * FROM onek2 WHERE unique1 = 60; 31FETCH all in foo13; 32 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 33---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 34 50 | 253 | 0 | 2 | 0 | 10 | 0 | 50 | 50 | 50 | 50 | 0 | 1 | YBAAAA | TJAAAA | HHHHxx 35(1 row) 36 37FETCH all in foo14; 38 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 39---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 40 51 | 76 | 1 | 3 | 1 | 11 | 1 | 51 | 51 | 51 | 51 | 2 | 3 | ZBAAAA | YCAAAA | AAAAxx 41(1 row) 42 43FETCH all in foo15; 44 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 45---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 46 52 | 985 | 0 | 0 | 2 | 12 | 2 | 52 | 52 | 52 | 52 | 4 | 5 | ACAAAA | XLBAAA | HHHHxx 47(1 row) 48 49FETCH all in foo16; 50 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 51---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 52 53 | 196 | 1 | 1 | 3 | 13 | 3 | 53 | 53 | 53 | 53 | 6 | 7 | BCAAAA | OHAAAA | AAAAxx 53(1 row) 54 55FETCH all in foo17; 56 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 57---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 58 54 | 356 | 0 | 2 | 4 | 14 | 4 | 54 | 54 | 54 | 54 | 8 | 9 | CCAAAA | SNAAAA | AAAAxx 59(1 row) 60 61FETCH all in foo18; 62 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 63---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 64 55 | 627 | 1 | 3 | 5 | 15 | 5 | 55 | 55 | 55 | 55 | 10 | 11 | DCAAAA | DYAAAA | VVVVxx 65(1 row) 66 67FETCH all in foo19; 68 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 69---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 70 56 | 54 | 0 | 0 | 6 | 16 | 6 | 56 | 56 | 56 | 56 | 12 | 13 | ECAAAA | CCAAAA | OOOOxx 71(1 row) 72 73FETCH all in foo20; 74 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 75---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 76 57 | 942 | 1 | 1 | 7 | 17 | 7 | 57 | 57 | 57 | 57 | 14 | 15 | FCAAAA | GKBAAA | OOOOxx 77(1 row) 78 79FETCH all in foo21; 80 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 81---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 82 58 | 114 | 0 | 2 | 8 | 18 | 8 | 58 | 58 | 58 | 58 | 16 | 17 | GCAAAA | KEAAAA | OOOOxx 83(1 row) 84 85FETCH all in foo22; 86 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 87---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 88 59 | 593 | 1 | 3 | 9 | 19 | 9 | 59 | 59 | 59 | 59 | 18 | 19 | HCAAAA | VWAAAA | HHHHxx 89(1 row) 90 91FETCH all in foo23; 92 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 93---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 94 60 | 483 | 0 | 0 | 0 | 0 | 0 | 60 | 60 | 60 | 60 | 0 | 1 | ICAAAA | PSAAAA | VVVVxx 95(1 row) 96 97FETCH all in foo24; 98 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 99---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 100 50 | 253 | 0 | 2 | 0 | 10 | 0 | 50 | 50 | 50 | 50 | 0 | 1 | YBAAAA | TJAAAA | HHHHxx 101(1 row) 102 103FETCH all in foo25; 104 unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 105---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- 106 60 | 483 | 0 | 0 | 0 | 0 | 0 | 60 | 60 | 60 | 60 | 0 | 1 | ICAAAA | PSAAAA | VVVVxx 107(1 row) 108 109CLOSE foo13; 110CLOSE foo14; 111CLOSE foo15; 112CLOSE foo16; 113CLOSE foo17; 114CLOSE foo18; 115CLOSE foo19; 116CLOSE foo20; 117CLOSE foo21; 118CLOSE foo22; 119CLOSE foo23; 120CLOSE foo24; 121CLOSE foo25; 122END; 123