Question: 6. Create a MESSAGES table and insert several rows into it. A. To create the messages table. DROP TABLE messages; CREATE TABLE messages (results NUMBER(2));
6. Create a MESSAGES table and insert several rows into it. A. To create the messages table. DROP TABLE messages; CREATE TABLE messages (results NUMBER(2)); B. Write a PL/SQL block to insert numbers into the MESSAGES table. Insert the numbers 1 through 10, excluding 6 and 8. DECLARE V_numbero number(2):=1; Begin Loop If v_numbre number<>6 and v_numbre<>8 then Insert into messages(results) values(v_numbre); End if; V_numbre:=v__numbre+1; Exit when v_numbre>10; End loop; End;
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
