Mega Code Archive
A PLSQL procedure with no parameter
<![CDATA[
SQL>
SQL> CREATE TABLE MyTable (
2 num_col NUMBER,
3 char_col VARCHAR2(60)
4 );
Table created.
SQL>
SQL>
SQL> CREATE OR REPLACE PROCEDURE InsertIntoTemp AS
2 v_Num1 NUMBER := 1;
3 v_Num2 NUMBER := 2;
4 v_String1 VARCHAR2(50) := 'Hello World!';
5 v_String2 VARCHAR2(50) := '-- This message brought to you by PL/SQL!';
6 v_OutputStr VARCHAR2(50);
7 BEGIN
8 INSERT INTO MyTable (num_col, char_col)
9 VALUES (v_Num1, v_String1);
10 INSERT INTO MyTable (num_col, char_col)
11 VALUES (v_Num2, v_String2);
12
13 SELECT char_col
14 INTO v_OutputStr
15 FROM MyTable
16 WHERE num_col = v_Num1;
17 DBMS_OUTPUT.PUT_LINE(v_OutputStr);
18
19 SELECT char_col
20 INTO v_OutputStr
21 FROM MyTable
22 WHERE num_col = v_Num2;
23 DBMS_OUTPUT.PUT_LINE(v_OutputStr);
24
25 ROLLBACK;
26
27 END InsertIntoTemp;
28 /
Procedure created.
SQL>
SQL> BEGIN
2 InsertIntoTemp;
3 END;
4 /
Hello World!
-- This message brought to you by PL/SQL!
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> select * from MyTable;
no rows selected
SQL>
SQL>
SQL> drop table MyTable;
Table dropped.
SQL>
]]>