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 vote124 views1 answer
Sql remove first character from string
SQL
1 vote121 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote111 views1 answer
Dnsmasq.conf location macos
SQL
0 vote112 views1 answer
St_buffer mysql
SQL
38 votes128 views6 answers
Ubuntu install mysql client
SQL
1 vote117 views2 answers
Mysql join two tables
SQL
0 vote118 views2 answers
Plsql regex match whole word
SQL
0 vote129 views1 answer
Insert set mysql
SQL
0 vote125 views1 answer
Update and keep original value sql
SQL
0 vote127 views1 answer
Mssql + bit + in python orm
SQL