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

1 vote124 views2 answers
Reset mysqli fetch_arra
SQL
0 vote125 views2 answers
Sql regex vowel
SQL
5 votes115 views3 answers
Day of week postgresql
SQL
0 vote113 views1 answer
Mysql database hyphen
SQL
0 vote177 views3 answers
How to find all role in mysql
SQL
0 vote128 views1 answer
Create table as select sql server error
SQL
11 votes188 views1 answer
Oracle insert from select
SQL
0 vote124 views1 answer
Mysql sum with group by
SQL
0 vote163 views1 answer
SQL Server Altering Column to be Unique
SQL
9 votes132 views3 answers
Import DB through mysql console
SQL