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

0 vote392 views1 answer
Sql query use select name inside where clause
SQL
0 vote392 views1 answer
Select distinct after join
SQL
1 vote376 views1 answer
Postgres check blocking
SQL
2 votes357 views3 answers
Current month mysql query
SQL
3 votes353 views2 answers
Mysql HAVING
SQL
0 vote360 views1 answer
Find invalid datetime field
SQL
10 votes397 views5 answers
Create table mysql query
SQL
0 vote368 views1 answer
Sql server roles and users
SQL
2 votes404 views3 answers
Xampp mysql database not starting
SQL
1 vote349 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL