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 vote168 views1 answer
Leftjoin in sql
SQL
3 votes108 views1 answer
System.debug apex
SQL
-1 vote155 views1 answer
Phinehas Psalm 106
SQL
0 vote163 views1 answer
Format the money fied with comma in international system using sql
SQL
2 votes135 views1 answer
Sqlplus clear screen
SQL
0 vote253 views1 answer
Sqlite woth cmake
SQL
12 votes131 views5 answers
Sql merge
SQL
1 vote172 views1 answer
Mysql previous year
SQL
0 vote154 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
1 vote145 views1 answer
Mysql view command
SQL