Write one or more sql statements

Assignment Help Basic Computer Science

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

Reference no: EM13808369

Questions Cloud

As a financial analyst you are asked to advise a mnc about : Applying the Euro: Euro against U.S. dollar As a financial analyst, you are asked to advise a MNC about its one-year investment plan next year in Germany. Because the investment is denominated in euros, you are asked to forecast how the euro's value ..

What classes categories of needs does keynes say there are : What two classes (categories) of needs does Keynes say there are? Explain each one. Do you think his ideas about this are correct? Why, or why not?

Develop an understanding about the life cycle : This assignment will help you develop an understanding about the life cycle of supply chains including the models that are aligned with it and the cost it bears. In addition, you will develop an awareness of the elements of the supply chain that s..

Write one or more sql statements : 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

Perform established products in mainstream markets : While these may under perform established products in mainstream markets, they often offer features or capabilities appreciated by some fringe customer group.

Assuming an annual inflation : You purchased a machine for $750,000 (installed), and you depreciated it using a 7 year MACRS. This machine generates $300,000 in revenue. In the prior problem, assume that you have a 12% MARR, What is your NPW and IRR? NPW? You think that you need $..

As you educate the security staff on cryptographic concepts : As you educate the security staff on cryptographic concepts, you also will soon make recommendations on the tools that will be appropriate for this company. You will address the topic of digital signatures with the staff. Present the concepts of digi..

Assignment on utilitarianism on pornography : Utilitarianism on Pornography

User Account

All Pages