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

10 votes124 views4 answers
Join with multiple conditions sql
SQL
0 vote139 views1 answer
Procedures sql insert mysql
SQL
1 vote138 views1 answer
Print all records of table in mysql
SQL
1 vote155 views1 answer
Limit offset order by mysql
SQL
1 vote133 views1 answer
Group_concat order by
SQL
2 votes164 views1 answer
Datefromparts mssql
SQL
7 votes144 views3 answers
Convert ansi sql
SQL
0 vote141 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
0 vote141 views1 answer
Sql put two columns into one
SQL
1 vote155 views1 answer
Add sequence postgres
SQL