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 vote336 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote322 views1 answer
Oracle call a function in a insert statement
SQL
0 vote347 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
13 votes352 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote342 views1 answer
Mysql DDL
SQL
1 vote330 views1 answer
Mysql show long running queries
SQL
6 votes349 views2 answers
Postgresql pg_dump
SQL
10 votes343 views1 answer
User_dependencies
SQL
7 votes346 views2 answers
Mysql get year from date
SQL
0 vote374 views1 answer
FIND most frequent word in sql server
SQL