Select two columns into a cursor variable

    


SQL> CREATE TABLE products(
  2    name            VARCHAR2(50),
  3    price      NUMBER(8,2),
  4    min_price       NUMBER(8,2)
  5  );

Table created.

SQL>
SQL>
SQL> create or replace procedure print_products
  2    as
  3      cursor dataCursor is select name, price from products;
  4    begin
  5        for i in dataCursor LOOP
  6           if i.price > 50 then
  7              dbms_output.put_line(i.name ||' Price: '|| i.price);
  8           else
  9              dbms_output.put_line(i.name || ' Product under 50');
 10           end if;
 11       END LOOP;
 12   end;
 13  /

Procedure created.

SQL>
SQL> describe print_products
PROCEDURE print_products

SQL>
SQL>
SQL> drop table products;

Table dropped.

SQL>
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.	Output variable after 'select into'
7.	SELECT into value pair
8.	Select the number of employees into the l_emp_count variable
9.	Select into and subquery
10.	Select single value into 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

Select two columns into a cursor variable : Select Into « PL SQL « Oracle PL / SQL

Related examples in the same category