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)
);