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 vote182 views1 answer
Limit in access query
SQL
0 vote194 views1 answer
Oracle cpu metric
SQL
1 vote181 views4 answers
Mysqldump 1 table only
SQL
0 vote169 views1 answer
How should I pass a table name into a stored proc?
SQL
1 vote162 views1 answer
How to delete record sql delphi
SQL
0 vote163 views1 answer
Sqlalchemy query sql compiled
SQL
10 votes234 views2 answers
Reset mysql root password mac
SQL
1 vote176 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote167 views2 answers
Sqlite
SQL
0 vote200 views1 answer
Add new column in sql with foreign key
SQL