26:
27:
28: BEGIN
29:
30: dbms_output.enable(1000000);
31:
32: OPEN c_cnt_rows;
33: FETCH c_cnt_rows INTO p_num_rows;
34: CLOSE c_cnt_rows;
32: OPEN c_cnt_rows;
33: FETCH c_cnt_rows INTO p_num_rows;
34: CLOSE c_cnt_rows;
35:
36: dbms_output.put_line('The number of rows is: ' || to_char(p_num_rows));
37: END; -- procedure cnt_rows.
38:
39:
40: PROCEDURE est_row_len(p_from_date DATE,
66:
67:
68: BEGIN
69:
70: dbms_output.enable(1000000);
71:
72: OPEN c_1;
73: FETCH c_1 INTO
74: X_DIRECTION;
85: x_total := x_total + 2*ceil(x_INSTANCE + 1);
86:
87: x_total := x_total + 15*(x_constant + 1);
88:
89: -- dbms_output.put_line(' ');
90: dbms_output.put_line('The average row length is : ' || to_char(x_total));
91:
92: p_avg_row_len := x_total;
93:
86:
87: x_total := x_total + 15*(x_constant + 1);
88:
89: -- dbms_output.put_line(' ');
90: dbms_output.put_line('The average row length is : ' || to_char(x_total));
91:
92: p_avg_row_len := x_total;
93:
94: END; -- procedure est_row_len.