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 vote193 views2 answers
Get day in sql
SQL
1 vote194 views1 answer
Mysql date diff in seconds
SQL
1 vote217 views1 answer
Mysql show current queries
SQL
0 vote201 views1 answer
Désinstaller postgresql linux
SQL
0 vote193 views1 answer
Import big data to mysql
SQL
42 votes273 views6 answers
Install beautifulsoup
SQL
1 vote325 views1 answer
Concat first name and last name in mysql
SQL
0 vote232 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote216 views1 answer
Hour differeence in mysql
SQL
0 vote239 views1 answer
Display all node label neo4j
SQL