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 vote293 views1 answer
Mysql query bulk insert
SQL
0 vote308 views1 answer
How to set sql_mode for a query in CI model
SQL
5 votes279 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote283 views1 answer
Replace null value within column mysql
SQL
2 votes296 views1 answer
Sql update from different table
SQL
0 vote274 views1 answer
Sql comparison operators
SQL
0 vote295 views1 answer
Update sqlite
SQL
2 votes296 views2 answers
Postgres select duplicate columns
SQL
3 votes444 views9 answers
Linq to sql converter online
SQL
2 votes290 views1 answer
Oracle sql day of month from date
SQL