Question: Copy and run the following code and then answer the questions that follow: CREATE OR REPLACE TYPE vcarray AS VARRAY(10) OF VARCHAR2(128); / CREATE TABLE
Copy and run the following code and then answer the questions that follow:
CREATE OR REPLACE TYPE vcarray AS VARRAY(10) OF VARCHAR2(128);
/
CREATE TABLE varray_table (id number primary key, col1 vcarray);
INSERT INTO varray_table VALUES (1, vcarray('A'));
INSERT INTO varray_table VALUES (2, vcarray('B', 'C'));
INSERT INTO varray_table VALUES (3, vcarray('D', 'E', 'F'));
2.1 Write an anonymous block to display the following output: (5 points)
ID: 1
A
ID: 2
B
C
ID: 3
D
E
F
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
