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 votes203 views1 answer
Q operator in plsql
SQL
11 votes238 views5 answers
Laravel db facade
SQL
0 vote228 views1 answer
Sqlalchemy case insensitive like
SQL
1 vote192 views2 answers
Mysql spring boot application.properties
SQL
0 vote209 views1 answer
How we can perform acid Operations in sql with examples
SQL
-1 vote266 views4 answers
Full outer join in sql
SQL
0 vote228 views1 answer
Separator mysql
SQL
21 votes210 views4 answers
Oracle add column
SQL
0 vote225 views1 answer
SQL Where-Klausel
SQL
1 vote220 views1 answer
Oracle insert multiple rows into same table
SQL