|
--验证:
SQL> set serveroutput on size 1000000;
SQL> --(A)
SQL>
SQL> CREATE OR REPLACE PROCEDURE plch_show_amounts (
2 amount1_in IN NUMBER
3 , amount2_in IN NUMBER)
4 IS
5 PROCEDURE show_one (amount_in IN NUMBER)
6 AS
7 BEGIN
8 DBMS_OUTPUT.put_line (
9 TO_CHAR (amount1_in, 'FML999G999D99'));
10 END;
11 BEGIN
12 show_one (plch_show_amounts.amount1_in);
13 show_one (plch_show_amounts.amount2_in);
14 END;
15 /
Procedure created
SQL> exec plch_show_amounts (100.45, 452666.77);
RMB100.45
RMB100.45
PL/SQL procedure successfully completed
SQL>
SQL> --(B)
SQL> CREATE OR REPLACE PROCEDURE plch_show_amounts (
2 amount1_in IN NUMBER
3 , amount2_in IN NUMBER)
4 IS
5 PROCEDURE show_one (amount_in IN NUMBER)
6 AS
7 BEGIN
8 DBMS_OUTPUT.put_line (
9 TO_CHAR (amount_in, 'FML999G999D99'));
10 END;
11 BEGIN
12 show_one (plch_show_amounts.amount1_in);
13 show_one (plch_show_amounts.amount2_in);
14 END;
15 /
Procedure created
SQL> exec plch_show_amounts (100.45, 452666.77);
RMB100.45
RMB452,666.77
PL/SQL procedure successfully completed
SQL>
SQL> --(C)
SQL> CREATE OR REPLACE PROCEDURE plch_show_amounts (
2 amount1_in IN NUMBER
3 , amount2_in IN NUMBER)
4 IS
5 PROCEDURE show_one (amount1_in IN NUMBER)
6 AS
7 BEGIN
8 DBMS_OUTPUT.put_line (
9 TO_CHAR (amount1_in, 'FML999G999D99'));
10 END;
11 BEGIN
12 show_one (plch_show_amounts.amount1_in);
13 show_one (plch_show_amounts.amount2_in);
14 END;
15 /
Procedure created
SQL> exec plch_show_amounts (100.45, 452666.77);
RMB100.45
RMB452,666.77
PL/SQL procedure successfully completed
SQL>
SQL> --(D)
SQL> CREATE OR REPLACE PROCEDURE plch_show_amounts (
2 amount1_in IN NUMBER
3 , amount2_in IN NUMBER)
4 IS
5 PROCEDURE show_one (amount1_in IN NUMBER)
6 AS
7 BEGIN
8 DBMS_OUTPUT.put_line (
9 TO_CHAR (plch_show_amounts.amount1_in, 'FML999G999D99'));
10 END;
11 BEGIN
12 show_one (plch_show_amounts.amount1_in);
13 show_one (plch_show_amounts.amount2_in);
14 END;
15 /
Procedure created
SQL> exec plch_show_amounts (100.45, 452666.77);
RMB100.45
RMB100.45
PL/SQL procedure successfully completed
|
|