equal
deleted
inserted
replaced
29 |
29 |
30 Useful PL/SQL stub. |
30 Useful PL/SQL stub. |
31 =================== |
31 =================== |
32 :: |
32 :: |
33 |
33 |
34 set serveroutput on; |
|
35 set autotrace on statistics; |
34 set autotrace on statistics; |
36 set timing on; |
35 set timing on; |
37 |
36 |
38 declare |
37 declare |
39 begin |
38 begin |
47 x number; |
46 x number; |
48 begin |
47 begin |
49 select 1 into x from dual; |
48 select 1 into x from dual; |
50 end; |
49 end; |
51 / |
50 / |
|
51 |
|
52 Enabling printing:: |
|
53 |
|
54 set serveroutput on; |
|
55 exec DBMS_OUTPUT.PUT_LINE('Hello'); |
|
56 exec DBMS_OUTPUT.DISABLE(); |
|
57 exec DBMS_OUTPUT.PUT_LINE('Silence'); |
|
58 exec DBMS_OUTPUT.ENABLE(); |
52 |
59 |
53 Database info. |
60 Database info. |
54 ============== |
61 ============== |
55 |
62 |
56 List of users:: |
63 List of users:: |