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

7 votes208 views2 answers
Add column table pl sql
SQL
3 votes240 views1 answer
Create a table with an id in mysql
SQL
0 vote233 views1 answer
Load data infile mariadb slow
SQL
0 vote219 views1 answer
Sql server select furst day of current year
SQL
0 vote223 views3 answers
Sql drop all tables
SQL
0 vote218 views1 answer
Oracle show grants on table
SQL
10 votes220 views3 answers
Sql select between two dates
SQL
10 votes222 views4 answers
Sql pagination
SQL
0 vote215 views1 answer
Data types mysql vs postgresql
SQL
1 vote220 views1 answer
How to change owner in postgres
SQL