equal
deleted
inserted
replaced
25 HTML, JavaScript, BPEL and PHP. |
25 HTML, JavaScript, BPEL and PHP. |
26 http://en.wikipedia.org/wiki/Oracle_Reports |
26 http://en.wikipedia.org/wiki/Oracle_Reports |
27 Oracle Reports is a tool for developing reports against data |
27 Oracle Reports is a tool for developing reports against data |
28 stored in an Oracle database. |
28 stored in an Oracle database. |
29 |
29 |
30 Useful PL/SQL stub. |
30 Useful PL/SQL stubs |
31 =================== |
31 =================== |
32 :: |
32 :: |
33 |
33 |
34 set autotrace on statistics; |
34 set autotrace on statistics; |
35 set timing on; |
35 set timing on; |
54 set serveroutput on; |
54 set serveroutput on; |
55 exec DBMS_OUTPUT.PUT_LINE('Hello'); |
55 exec DBMS_OUTPUT.PUT_LINE('Hello'); |
56 exec DBMS_OUTPUT.DISABLE(); |
56 exec DBMS_OUTPUT.DISABLE(); |
57 exec DBMS_OUTPUT.PUT_LINE('Silence'); |
57 exec DBMS_OUTPUT.PUT_LINE('Silence'); |
58 exec DBMS_OUTPUT.ENABLE(); |
58 exec DBMS_OUTPUT.ENABLE(); |
|
59 |
|
60 Call procedure:: |
|
61 |
|
62 create or replace procedure MY_PROC as |
|
63 begin |
|
64 null; |
|
65 end; |
|
66 / |
|
67 |
|
68 begin |
|
69 MY_PROC; |
|
70 end; |
|
71 / |
|
72 |
|
73 Call function:: |
|
74 |
|
75 create or replace function MY_FUN return number as |
|
76 begin |
|
77 return 42; |
|
78 end; |
|
79 / |
|
80 |
|
81 declare |
|
82 x NUMBER; |
|
83 begin |
|
84 ret := MY_FUN(); |
|
85 end; |
|
86 / |
59 |
87 |
60 Database info. |
88 Database info. |
61 ============== |
89 ============== |
62 |
90 |
63 List of users:: |
91 List of users:: |