testsqlhosting/procs.sql at main · mestebanez/testsqlhosting · 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

drop table if exists accounts;

create or replace procedure ##_app_owner.CONSOLIDATED_VIEW$other_file_procedure
(
                 books in BOOK_IN_OT,
                 detail in DETAIL_TT,
                 min_len out int,
                 max_len out int,
                 avg_len out numeric,
                 books out BOOK_OUT_OT,
                 bla TEST.VALUE%TYPE,
                 fruit OUT TEST2.VALUE%TYPE
                 )
             language plpgsql
             as $$
             begin
               select min(length),
                      max(length),
                     avg(length)::numeric(5,1)
               into min_len, max_len, avg_len
               from film;
             end;$$

create or replace procedure ##_app_owner.CONSOLIDATED_VIEW$get_film_stat(
                 booksin in BOOK_IN_OT,
                 min_len out int,
                 max_len out int,
                 avg_len out numeric,
                 booksout out BOOK_OUT_OT)
             language plpgsql
             as $$
             begin
               select min(length),
                      max(length),
                     avg(length)::numeric(5,1)
               into min_len, max_len, avg_len
               from film;
             end;$$

 create or replace procedure ##_app_owner.CONSOLIDATED_VIEW$other_file_procedure1 (
                  books in BOOK_IN_OT,
                  min_len out int,
                  max_len out int,
                  avg_len out numeric,
                  books out BOOK_OUT_OT)
              language plpgsql
              as $$
              begin
                select min(length),
                       max(length),
                      avg(length)::numeric(5,1)
                into min_len, max_len, avg_len
                from film;
              end;$$