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 vote141 views1 answer
ORA-13717
SQL
4 votes143 views2 answers
Oracle drop job
SQL
0 vote144 views1 answer
Dump db only triggers mysql
SQL
0 vote125 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote160 views1 answer
Pgadmin check database
SQL
2 votes131 views1 answer
Postgresql change value in column
SQL
0 vote137 views1 answer
Qt qsql check if table exist
SQL
4 votes201 views1 answer
Sql select limit range
SQL
0 vote141 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote151 views1 answer
Sql query to find duplicate email address
SQL