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 vote320 views1 answer
Distinct data types in a table sql query
SQL
2 votes338 views2 answers
Get all tables using like
SQL
20 votes334 views6 answers
Mysql reset auto increment
SQL
0 vote307 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
27 votes378 views3 answers
Mysql delete row
SQL
0 vote329 views1 answer
Sql find record cannot cast date
SQL
0 vote311 views1 answer
Dump multiple tables mysql
SQL
0 vote324 views1 answer
Mariadb date equals to current_date plus days
SQL
6 votes293 views1 answer
Oracle trigger after connect
SQL
0 vote319 views1 answer
T sql cursor tr
SQL