Oracle sql for each row

DECLARE
  CURSOR c_product
  IS
    SELECT 
        product_name, list_price
    FROM 
        products 
    ORDER BY 
        list_price DESC;
BEGIN
  FOR r_product IN c_product
  LOOP
    dbms_output.put_line( r_product.product_name || ': $' ||  r_product.list_price );
  END LOOP;
END;

Source: oracletutorial.com

Oracle sql for each row

BEGIN
  FOR r_product IN (
        SELECT 
            product_name, list_price 
        FROM 
            products
        ORDER BY list_price DESC
    )
  LOOP
     dbms_output.put_line( r_product.product_name ||
        ': $' || 
        r_product.list_price );
  END LOOP;
END;

Source: oracletutorial.com

Similar codes

2 votes212 views1 answer
Sql find not in list
SQL
7 votes198 views5 answers
Oracle alter table
SQL
1 vote196 views1 answer
Check message id sql server
SQL
0 vote234 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote230 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote193 views1 answer
How to generate ids in sql
SQL
0 vote188 views1 answer
Oracle sql log to console
SQL
0 vote207 views1 answer
Sql cnvert bit to nvarchar
SQL
1 vote210 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote214 views1 answer
Tsql table column constraint must be uppercase
SQL