SQL Consider the table structure shown. Column Name vendor id Data Type Nullable

Question

SQL

Consider the table structure shown. Column Name vendor id Data Type Nullable Default Data Constraint numberNo varchar2(50) No varchar2(50) Yes varchar2(50) Yes PK UNIQUE addressi address2 char(2) No varchar2(20) No varchar2(50) Yes vendor contact last name varchar2(50) Yes vendor contact first name varchar2(50) Yes number No default account number number No vendor state vendor zip code vendor phone default terms id FK FK Write a command to add a row to this table where all fields that can be left null are left nul. The vondor to be added is Riloy's Office Equipment in Houston. Torms ids are from 1 through 5. The account number used the most for this vendor is number 170 Other Equipment

Explanation / Answer

Let suppose it is Oracle database, please see the below query, Create the table and run the query.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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