в 13:45, 26 мая 2010

2010-05-26T13:45:46Z

Admin: 1 версия

2010-05-26T10:11:45Z

1 версия

Новая страница

== Output to the SQL plus==



<source lang="sql">
SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 a_name VARCHAR2(30) := "AAAA";
3
4 PROCEDURE name_print IS
5 BEGIN
6 DBMS_OUTPUT.PUT_LINE(a_name);
7 END;
8
9 BEGIN
10 DBMS_OUTPUT.PUT_LINE(a_name);
11
12 DECLARE
13 b_name VARCHAR2(30) := "BBBB";
14 BEGIN
15 DBMS_OUTPUT.PUT_LINE("Inside nested block");
16 DBMS_OUTPUT.PUT_LINE(a_name);
17 DBMS_OUTPUT.PUT_LINE(b_name);
18 name_print;
19 END;
20
21 DBMS_OUTPUT.PUT_LINE("Back in the main block");
22
23 --But we cannot compile the following line because b_name
24 --is not defined in this block.
25 --DBMS_OUTPUT.PUT_LINE(b_name);
26
27 --Our procedure, however, can access the value of a_name.
28 name_print;
29 END;
30 /
AAAA
Inside nested block
AAAA
BBBB
AAAA
Back in the main block
AAAA
PL/SQL procedure successfully completed.
SQL></source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL Tutorial/Function Procedure Packages/Print Output - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия