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 vote247 views1 answer
Aqua Data studio postgresql ssl
SQL
7 votes164 views2 answers
Where keyword sql
SQL
8 votes159 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
1 vote164 views1 answer
Sql select max value from multiple rows
SQL
0 vote163 views1 answer
EnvironmentError: mysql_config not found
SQL
12 votes154 views4 answers
Mysql version
SQL
45 votes233 views5 answers
Grant all privileges mysql
SQL
0 vote153 views2 answers
Oracle chain rules
SQL
1 vote150 views1 answer
Postgres first_value in gropby
SQL
1 vote151 views3 answers
Sql select only time from datetime
SQL