Reference no: EM13808369

Need assistance answering this: Write one or more SQL statements that modify the table STUDENT such that the attribute PHONE is an array of phone_obj.Below is the first query i created and added to the STUDENT TABLE

CREATE TABLE STUDENT
(STUDENT_ID NUMBER(8,0) 
,SALUTATION VARCHAR2(5)
,FIRST_NAME VARCHAR2(25)
,LAST_NAME VARCHAR2(25) 
,STREET_ADDRESS VARCHAR2(50)
,ZIP VARCHAR2(5) 
,PHONE VARCHAR2(15)
,EMPLOYER VARCHAR2(50)
,REGISTRATION_DATE DATE 
,CREATED_BY VARCHAR2(30) 
,CREATED_DATE DATE 
,MODIFIED_BY VARCHAR2(30) 
,MODIFIED_DATE DATE 
)
/

ALTER TABLE Student
ADD (Phone_Obj VARCHAR (30));

CREATE OR REPLACE TYPE phone_obj AS OBJECT (
COUNTRY_Code varchar(2),
AREA_CODE varchar(3),
PHONE_NUMBER varchar(10)
);