Question: Have proper use of data types, meaningful comments, functionality and displaying the output. Your output should look like the screen shots shown. Get a Pl/SQL
Have proper use of data types, meaningful comments, functionality and displaying the output. Your output should look like the screen shots shown. Get a Pl/SQL subprogram, which has two blocks. An outer block declares two variables namedxandcounterand loops four times. Inside this loop is a sub-block that also declares a variable namedx. The values inserted into the temp table show that the twox 'sare indeed different. You will have to create the table temp as follows
CREATE TABLE TEMP(
NUM_ONE NUMBER(5),
NUM_TWO NUMBER(2),
CHAR_OUT VARCHAR2(30));
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
