Page 1 of 1
an After analyzing the below code, how many rows are being inserted ? Declare v_max_order order_menu.orderlD%TYPE; v_max
Posted: Sat Nov 27, 2021 10:28 am
by answerhappygod
- An After Analyzing The Below Code How Many Rows Are Being Inserted Declare V Max Order Order Menu Orderld Type V Max 1 (131.45 KiB) Viewed 86 times
an After analyzing the below code, how many rows are being inserted ? Declare v_max_order order_menu.orderlD%TYPE; v_max_date order_menu.orderdate%TYPE; Begin select max(orderlD) into v_max_order from order_menu; DBMS_OUTPUT.PUT_LINE( v_max_order | Total Orders'); select max[orderdate) into v_max_date from order_menu; DBMS_OUTPUT.PUT_LINE( v_max_date || 'Order Date'); update order_menu set orderdate = v_max_date where orderlD = 4; A DBMS_OUTPUT.PUT_LINE( SQL%ROWCOUNT I'data are updated'); insert into order menu values (v_max_order+1,v_max_date+1, 'Salalah'); DBMS_OUTPUT.PUT_LINE( SQL%ROWCOUNT | Rows are inserted"); End; O a. 1 Total Orders. O b. 1 Rows are inserted. Oc Error is triggered because of coding. O d. 1 record is inserted. be here to search C 3 e ae F2 F3 F4 z F5 OG F6 F7 F8 F9 F10 F11 # $ % 1 لد & 3 * ۲ 4 کی 5 o 6 ។ 7 V 8 A E 9 R TYY ! U 1