I have a table named SUPPLIER that is set up like this SUPPLIER(SupplierName(PK)

Question

I have a table named SUPPLIER that is set up like this

SUPPLIER(SupplierName(PK), ContactName, Notes, PhoneNumber, Email).

This table is already populated with records and we had to add a city and state column so now the table looks like this

SUPPLIER(SupplierName(PK), ContactName, Notes, PhoneNumber, Email, city, state).

My question is how can I add the city and state data to this table with one statement instead of multiple INSERT WHERE statements. Currently all city and states are null and I need to add the given city and state data.

Thank you,

Brad

Explanation / Answer

This would add the columns city and state:-

ALTER TABLE SUPPLIER

ADD (city varchar2(45),

state varchar2(45));

To populate it with data with single insert statement:-

INSERT INTO SUPPLIER(city,state)VALUES

('City1', 'state1'),('city2','state2'),('city3','state3')...;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.