I need help creating an insert syntax for these tables Product Table PRODUCT ID

Question

I need help creating an insert syntax for these tables

Product Table PRODUCT ID PKI PRODUCT NANEI PRODUCT PRICE PODUCT TTPE ID FKI B209 Bottled water $199 Span lingWater $249 Sam Pellegrino Raspbenry Lime $249 Lemon Seltzer $249 Orgric Strawbery $249 poradise Juice 8249 Green Tea Bottled Lemonade 6259 Iced Tea 8209 Lemonade 8209 Ked Green Tea 1 Iced Chai Tea Lotte 6209 Carrot Pineapple $389 Power Smoothie Low Fat Strawbery Barama Power oothie 1 Smoothie $4.29 Superfruit Power $429 Frozen Caramel 29 Hot Coffee B209 Hot Tea $169 1 Iced Coffe 1 Hot Chocolate $2.09 Tea Latte E389 8169 2 Travel Refill 1 Caramel Latte $3.39 1 1 Caffe Latte $339 1 Skiray Caffe 2 Peppermint Mocha E39 2 Caffe Mocha $3.39 1 2 Cappuccino E339 1 2 Espresso 1 2 Iced Caramel 63.89 1 elLatte 2 Iced Coffe ntochan 3.89 1 2 Iced Caffe Latte E339 1 2 Juice E249 2 Apple Juice 69 2 3169 2 Chocolate 3119

Explanation / Answer

Syntax for creating tables :

create table Product(product_id number primary key,product_name varchar2(20),product_price varchar2(5),product_type_id number,foreign key(product_type_id) references product_type(product_type_id));
create table product_type(product_type_id number primary key,product_description varchar2(30));

Syntax for inserting data into 2 tables :

insert into product_type values(5,'Fountain and Bottled Drinks');

insert into product values(1,'soda','$2.09',5);

Here we insert product price as string

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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