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 vote100 views1 answer
Postgresql convert text to float
SQL
11 votes56 views1 answer
Reset identity sql server
SQL
0 vote110 views1 answer
Delete ids between sql
SQL
1 vote105 views1 answer
Mariadb get column names from table
SQL
0 vote105 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote117 views1 answer
Mysql extract day from date leading zero
SQL
3 votes112 views2 answers
Postgres alter table owner
SQL
23 votes92 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote116 views1 answer
How to inner join 4 tables in sql
SQL
38 votes164 views4 answers
Count sql
SQL