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

5 votes256 views1 answer
Oracle asynchronous query
SQL
0 vote259 views2 answers
How to update the multiple rows in sql
SQL
1 vote290 views1 answer
Connect to mysql database ubuntu
SQL
0 vote260 views1 answer
Openquery insert into linked server
SQL
2 votes280 views1 answer
Can you use a where clause for a child query
SQL
0 vote269 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote262 views1 answer
Multiple left join mysql
SQL
2 votes293 views1 answer
Get the mysql table columns data type mysql
SQL
1 vote258 views2 answers
Update with inner join sql server
SQL
0 vote252 views1 answer
Version and edition of SQL Server Database Engine
SQL