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 vote196 views1 answer
Generate sql from specific migration ef core
SQL
12 votes133 views4 answers
SQL Where
SQL
1 vote237 views1 answer
Oracle current sequence value
SQL
0 vote159 views1 answer
Transaction and commit trong sql server
SQL
0 vote99 views1 answer
Bigquery information_schema schema all columns
SQL
5 votes723 views1 answer
Oracle ora-00054 find
SQL
0 vote137 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
-1 vote145 views1 answer
Auto increment psql not primary key
SQL
0 vote155 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote140 views2 answers
How to update date in oracle
SQL