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 vote219 views1 answer
Learnxinyminutes sql
SQL
0 vote207 views1 answer
Where date in datetime mysql
SQL
0 vote203 views3 answers
ChAnge TABLE name apex oracle
SQL
1 vote213 views1 answer
Adding a check statement in sql
SQL
0 vote241 views1 answer
C# sql transaction multiple connections
SQL
0 vote205 views1 answer
Cast float mysql
SQL
0 vote195 views1 answer
Connect postgresql using a connection string
SQL
1 vote223 views1 answer
Sqlalchemy order by descending
SQL
0 vote196 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote202 views1 answer
What is SQL data store?
SQL