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 vote344 views1 answer
Create sqlite database in laravel
SQL
0 vote333 views1 answer
SQL get max per id
SQL
0 vote363 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote353 views1 answer
Mysql Like(searching in the string)
SQL
1 vote336 views1 answer
Sql auto date
SQL
1 vote349 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote403 views1 answer
How to get button for every record from mysql
SQL
0 vote332 views1 answer
MySQL error code 2068
SQL
1 vote372 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
1 vote364 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL