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 vote155 views0 answer
SQL
1 vote184 views1 answer
Postgres install unaccent extension
SQL
0 vote197 views1 answer
Write SQL in ruby on rails
SQL
11 votes194 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote192 views1 answer
Php select data from mysql database without column name
SQL
0 vote180 views1 answer
Oracle create table auto generated primary key
SQL
-1 vote197 views1 answer
Sql show custom constraints
SQL
0 vote187 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote175 views1 answer
Get create sql of hibernqte entity
SQL
0 vote184 views1 answer
Window function to forward fill
SQL