Output variable after 'select into'

     

SQL>
SQL> CREATE TABLE MyTable (
  2    num_col    NUMBER,
  3    char_col   VARCHAR2(60)
  4    );

Table created.

SQL>
SQL>
SQL> DECLARE
  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) VALUES (v_Num1, v_String1);
  9    INSERT INTO MyTable (num_col, char_col) VALUES (v_Num2, v_String2);
 10
 11    SELECT char_col INTO v_OutputStr FROM MyTable WHERE num_col = v_Num1;
 12    DBMS_OUTPUT.PUT_LINE(v_OutputStr);
 13
 14    SELECT char_col INTO v_OutputStr FROM MyTable WHERE num_col = v_Num2;
 15    DBMS_OUTPUT.PUT_LINE(v_OutputStr);
 16    ROLLBACK;
 17  END;
 18  /
Hello World!
-- This message brought to you by PL/SQL!

PL/SQL procedure successfully completed.

SQL>
SQL> drop table MyTable;

Table dropped.

SQL>

Related examples in the same category

1.	Select value from table into variable
2.	Oracle returns an error when a SELECT statement returns more than one row
3.	Catch too_many_rows Exception for 'Select into' statement
4.	Multiple-Row SELECT Command with Several Exception-Handling Routines
5.	Select count result into a variable
6.	SELECT into value pair
7.	Select the number of employees into the l_emp_count variable
8.	Select into and subquery
9.	Select single value into variable
10.	Select two columns into a cursor variable
11.	Select value into a number variable in a for loop
12.	Select value to variable one by one
13.	If no records are retrieved for a SELECT - INTO statement the following error is returned
14.	If too many records are returned for a SELECT - INTO statement the following error is returned
15.	no_data_found from select ... into
16.	select bulk collect into table collection
17.	Use subquery in pl/sql block
18.	This script demonstrates how to do a non-bulk select into elements of a PL/SQL table.
19.	TOO_MANY_ROWS exception and select into command
20.	Store max(salary) to a variable
21.	Store max(tableName.column) to tableName.column.type variable
22.	Bulk Collection: fetch a single row from the ALL_OBJECTS table.
23.	Calculate salary by adding salary with max(salary)
24.	Select data for update
25.	Select value from aggregate function to variable

Output variable after 'select into' : Select Into « PL SQL « Oracle PL / SQL

Related examples in the same category