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 vote184 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote193 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote231 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
10 votes176 views6 answers
Sql between
SQL
2 votes174 views1 answer
Set username and password for postgresql database
SQL
0 vote167 views1 answer
Change data type in mysql
SQL
0 vote168 views1 answer
Retornar apenas o ano mysql date
SQL
4 votes175 views1 answer
Postgresql list sequences
SQL
6 votes164 views1 answer
Postgresql add enum value
SQL
11 votes172 views2 answers
Import sql file laravel cmd
SQL