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

3 votes321 views2 answers
Sqlite show table definition
SQL
6 votes367 views3 answers
How to delete table sqlite
SQL
51 votes439 views6 answers
Change column name sql
SQL
2 votes329 views1 answer
Sql missing records from another table
SQL
22 votes404 views1 answer
Mysql workbench
SQL
0 vote332 views1 answer
Run mssql server terminal
SQL
0 vote338 views1 answer
Call function sql oracle with output put line
SQL
0 vote332 views1 answer
To change the database owner in SQL server
SQL
0 vote325 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote334 views1 answer
Sql server query database space available
SQL