Advertisement
Guest User

Untitled

a guest
Apr 8th, 2020
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.93 KB | None | 0 0
  1. DECLARE
  2.     v_saturday NUMBER := 0;
  3.     v_sunday NUMBER := 0;
  4.     v_weekday NUMBER := 0;
  5.     v_total NUMBER := 0;
  6.  
  7.     CURSOR csr_salesRecord IS
  8.         SELECT TO_CHAR(orddate, 'DAY') DAY, prodprice price, qty FROM ordertbl o, ordline ol, product p
  9.         WHERE o.ordno = ol.ordno
  10.         AND p.prodno = ol.prodno;
  11. BEGIN
  12.     FOR r_salesRecord IN csr_salesRecord
  13.     LOOP
  14.         IF UPPER(r_salesRecord.DAY) LIKE '%SATURDAY%' THEN
  15.             v_saturday := v_saturday + (r_salesRecord.price * r_salesRecord.qty);
  16.         ELSIF UPPER(r_salesRecord.DAY) LIKE '%SUNDAY%' THEN
  17.             v_sunday := v_sunday + (r_salesRecord.price * r_salesRecord.qty);
  18.         ELSE
  19.             v_weekday := v_weekday + (r_salesRecord.price * r_salesRecord.qty);
  20.         END IF;
  21.  
  22.     END LOOP;
  23.     v_total := v_saturday + v_sunday + v_weekday;
  24.  
  25. DBMS_OUTPUT.PUT_LINE(RPAD('Saturday', 15) || '$' || LPAD(TO_CHAR(v_saturday, 'fm999999.00'), 10));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement