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

1 vote271 views2 answers
Sql example query
SQL
5 votes273 views2 answers
Oracle list columns schema
SQL
0 vote275 views1 answer
Sql delete row from table where id
SQL
3 votes264 views5 answers
Mysql get last inserted id
SQL
5 votes303 views1 answer
Get column name sql server
SQL
0 vote275 views1 answer
Android sqlite add column if not exists
SQL
0 vote273 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote271 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote358 views1 answer
Php insert null mysql
SQL
1 vote275 views2 answers
List tables sqlalchemy
SQL