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 vote233 views1 answer
Partial search in sql
SQL
0 vote229 views1 answer
Creating sqeuence in oracle database
SQL
0 vote183 views1 answer
Procedure excute monthly oracle
SQL
1 vote231 views3 answers
Nth highest salary
SQL
0 vote188 views1 answer
Sqlite commands
SQL
2 votes191 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
1 vote216 views1 answer
Sql order by timestamp
SQL
6 votes216 views2 answers
Mysql 1 day ago
SQL
0 vote188 views1 answer
What is ssrs and ssis in sql server
SQL
12 votes201 views1 answer
Env var for setting password for root user mysql docker hub
SQL